This query is used to get the person number of the active line manager assigned to an employee as of a specific effective date.
This query selects the PERSON_NUMBER of a manager from PER_ALL_PEOPLE_F who is assigned as...
This query is used to get the date that is 12 months after the effective start date of an element entry value associated with a payroll relationship group.
This query selects the EFFECTIVE_START_DATE from PAY_ELEMENT_ENTRY_VALUES_F and calculates a new date by adding 12...
This query retrieves the screen entry value of an element entry input value (Amount or Total Amount) associated with a payroll relationship group.
This query selects the SCREEN_ENTRY_VALUE from PAY_ELEMENT_ENTRY_VALUES_F for element entries that contain input values with the...