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 gets the display name of the active line manager assigned to an employee based on the current system date.
This query selects the DISPLAY_NAME of a manager from PER_PERSON_NAMES_F who is assigned as...
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...