DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 146: ,pay_payroll_actions ppa

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
150: WHERE asg.assignment_id = paa.assignment_id

Line 1274: ,pay_payroll_actions ppa

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
1278: WHERE asg.assignment_id = paa.assignment_id

Line 2107: ,pay_payroll_actions ppa

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
2111: WHERE asg.assignment_id = paa.assignment_id

Line 2632: ,pay_payroll_actions ppa

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
2636: WHERE asg.assignment_id = paa.assignment_id

Line 2661: ,pay_payroll_actions ppa

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
2665: WHERE asg.assignment_id = paa.assignment_id

Line 2686: ,pay_payroll_actions ppa

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
2690: AND pos.period_of_service_id = asg.period_of_service_id

Line 2707: ,pay_payroll_actions ppa

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
2711: WHERE asg.assignment_id = paa.assignment_id

Line 3810: ,pay_payroll_actions ppa

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
3814: WHERE asg.assignment_id = paa.assignment_id

Line 4580: ,pay_payroll_actions ppa

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
4584: WHERE asg.assignment_id = paa.assignment_id