eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_NL_REM_REPORT dependencies on PER_PERIODS_OF_SERVICE

Line 1010: ,per_periods_of_service pps

1006: FROM pay_payroll_actions ppa
1007: ,pay_assignment_actions asg_act
1008: ,per_assignments_f paa
1009: ,pay_all_payrolls_f ppf
1010: ,per_periods_of_service pps
1011: ,hr_all_organization_units hou1
1012: ,per_all_people_f papf
1013: WHERE ppa.business_group_id = p_business_group_id
1014: AND ppa.action_type IN ('R','B','I'

Line 1834: ,per_periods_of_service pps

1830: SELECT DISTINCT
1831: papf.national_identifier sofi_number
1832: FROM per_all_people_f papf
1833: ,per_all_assignments_f paa
1834: ,per_periods_of_service pps
1835: ,pay_payroll_actions ppa
1836: ,pay_assignment_actions asg_act
1837: ,pay_all_payrolls_f ppf
1838: WHERE ppa.business_group_id = p_business_group_id

Line 1895: ,per_periods_of_service pps

1891: ,ppf.prl_information1) org_id
1892: , REPLACE(hou1.name,l_seperator,' ') employer_name
1893: FROM per_all_people_f papf
1894: ,per_all_assignments_f paa
1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act
1898: ,pay_all_payrolls_f ppf
1899: ,hr_all_organization_units hou1