SRAVAN ORACLE APPS HRMS

No posts with label SSHR Queries. Show all posts

Subscribe to: Posts (Atom)

Labels

Oracle Learning Management – OLM Tables

In Oracle HRMS Overview Series of Articles, This is the first to one to talk technical aspects of OLM (Oracle Learning Management). In this...
Query: Grade Rates

select pr.name "Rate", -- pgt.name "Grade Name", fcv....
Query: Grade Scale Rates

select pgtl.name "Grade Name" , -- pps.name "Pay Scale Name", ...
Query: Organization Manager

select org_tl.name "Organization", ppf.full_name ...
ORACLE APPS BOOKS

Oracle E-Business Suite Development and Extensibility Handbook By Anil Passi, Vladimir Ajvaz https://drive.google.com/file/d/0B4sGOfY_I...
Query: Contracts

select per.employee_number "Employee Number", -- p...
Oracle.E-Business.Suite.R12.Core.Development.and.Extension.Cookbook

https://drive.google.com/file/d/0B4sGOfY_IcSTSWE0UDV6WkI5Qm8/edit?usp=sharing
Terminate Employee Oracle EBS (Calling API)

Employee data could be terminated from back end using oracle HRMS API (HR_EX_EMPLOYEE_API.ACTUAL_TERMINATION_EMP). Declare CURSOR c_emp_...
Oracle HRMS Query for Grade and Salary History

Oracle HRMS Query to Get Previous Grade SELECT pg_old.name from apps.per_all_people_f papf, apps.per_all_assignments_f paaf_old, app...
HRMS

Oracle Applications for Human Resources enable an organization to hire, train, and deploy, assess, motivate and reward its peopl...