APPS.PAY_AE_SI_REPORTS dependencies on PER_PERIODS_OF_SERVICE

Line 148: ,per_periods_of_service pos

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
151: AND paa.payroll_action_id = ppa.payroll_action_id
152: AND pos.period_of_service_id = asg.period_of_service_id

Line 1276: ,per_periods_of_service pos

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
1279: AND paa.payroll_action_id = ppa.payroll_action_id
1280: AND pos.period_of_service_id = asg.period_of_service_id

Line 2109: ,per_periods_of_service pos

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
2112: AND paa.payroll_action_id = ppa.payroll_action_id
2113: AND pos.period_of_service_id = asg.period_of_service_id

Line 2634: ,per_periods_of_service pos

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
2637: AND paa.payroll_action_id = ppa.payroll_action_id
2638: AND pos.period_of_service_id = asg.period_of_service_id

Line 2663: ,per_periods_of_service pos

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
2666: AND paa.payroll_action_id = ppa.payroll_action_id
2667: AND pos.period_of_service_id = asg.period_of_service_id

Line 2687: ,per_periods_of_service pos

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
2691: AND ppa.action_type in ('R','Q')

Line 2709: ,per_periods_of_service pos

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
2712: AND paa.payroll_action_id = ppa.payroll_action_id
2713: AND pos.period_of_service_id = asg.period_of_service_id

Line 3812: ,per_periods_of_service pos

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
3815: AND paa.payroll_action_id = ppa.payroll_action_id
3816: AND pos.period_of_service_id = asg.period_of_service_id

Line 4582: ,per_periods_of_service pos

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
4585: AND paa.payroll_action_id = ppa.payroll_action_id
4586: AND pos.period_of_service_id = asg.period_of_service_id