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.

APPS.PAY_AE_SI_REPORTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 145: ,pay_assignment_actions paa

141: ,paa.assignment_action_id
142: ,ppa.date_earned
143: ,pos.date_start
144: FROM per_all_assignments_f asg
145: ,pay_assignment_actions paa
146: ,pay_payroll_actions ppa
147: ,hr_soft_coding_keyflex hscl
148: ,per_periods_of_service pos
149: ,per_all_people_f ppf

Line 1273: ,pay_assignment_actions paa

1269: ,pos.actual_termination_date
1270: ,pos.LEAVING_REASON
1271: ,ppa.date_earned
1272: FROM per_all_assignments_f asg
1273: ,pay_assignment_actions paa
1274: ,pay_payroll_actions ppa
1275: ,hr_soft_coding_keyflex hscl
1276: ,per_periods_of_service pos
1277: ,per_all_people_f ppf

Line 2106: ,pay_assignment_actions paa

2102: SELECT distinct asg.person_id
2103: ,paa.assignment_action_id
2104: ,ppa.date_earned
2105: FROM per_all_assignments_f asg
2106: ,pay_assignment_actions paa
2107: ,pay_payroll_actions ppa
2108: ,hr_soft_coding_keyflex hscl
2109: ,per_periods_of_service pos
2110: ,per_all_people_f ppf

Line 2631: ,pay_assignment_actions paa

2627: SELECT distinct asg.person_id
2628: ,paa.assignment_action_id
2629: ,pos.date_start
2630: FROM per_all_assignments_f asg
2631: ,pay_assignment_actions paa
2632: ,pay_payroll_actions ppa
2633: ,hr_soft_coding_keyflex hscl
2634: ,per_periods_of_service pos
2635: ,per_all_people_f ppf

Line 2660: ,pay_assignment_actions paa

2656: ,paa.assignment_action_id
2657: ,pos.actual_termination_date
2658: ,ppa.date_earned
2659: FROM per_all_assignments_f asg
2660: ,pay_assignment_actions paa
2661: ,pay_payroll_actions ppa
2662: ,hr_soft_coding_keyflex hscl
2663: ,per_periods_of_service pos
2664: ,per_all_people_f ppf

Line 2685: ,pay_assignment_actions paa

2681: /*Cursor for fetching effective date of salary change*/
2682: CURSOR csr_get_salary_date (p_person_id NUMBER, l_effective_date date) IS
2683: SELECT date_earned, paa.assignment_action_id
2684: FROM per_all_assignments_f asg
2685: ,pay_assignment_actions paa
2686: ,pay_payroll_actions ppa
2687: ,per_periods_of_service pos
2688: WHERE asg.assignment_id = paa.assignment_id
2689: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2706: ,pay_assignment_actions paa

2702: SELECT distinct asg.person_id
2703: ,paa.assignment_action_id
2704: ,date_earned
2705: FROM per_all_assignments_f asg
2706: ,pay_assignment_actions paa
2707: ,pay_payroll_actions ppa
2708: ,hr_soft_coding_keyflex hscl
2709: ,per_periods_of_service pos
2710: ,per_all_people_f ppf

Line 3809: ,pay_assignment_actions paa

3805: SELECT distinct asg.person_id
3806: ,paa.assignment_action_id
3807: ,ppa.date_earned
3808: FROM per_all_assignments_f asg
3809: ,pay_assignment_actions paa
3810: ,pay_payroll_actions ppa
3811: ,hr_soft_coding_keyflex hscl
3812: ,per_periods_of_service pos
3813: ,per_all_people_f ppf

Line 4579: ,pay_assignment_actions paa

4575: SELECT distinct asg.person_id
4576: ,paa.assignment_action_id
4577: ,ppa.date_earned
4578: FROM per_all_assignments_f asg
4579: ,pay_assignment_actions paa
4580: ,pay_payroll_actions ppa
4581: ,hr_soft_coding_keyflex hscl
4582: ,per_periods_of_service pos
4583: ,per_all_people_f ppf