APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PER_PERIODS_OF_SERVICE

Line 800: INDEX(pps per_periods_of_service_n3)

796: SELECT /*+ INDEX(pap per_people_f_pk)
797: INDEX(paa per_assignments_f_fk1)
798: INDEX(paa per_assignments_f_N12)
799: INDEX(rppa pay_payroll_actions_pk)
800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id
802: from per_people_f pap
803: ,per_assignments_f paa
804: ,pay_payroll_actions rppa

Line 805: ,per_periods_of_service pps

801: */ distinct paa.assignment_id
802: from per_people_f pap
803: ,per_assignments_f paa
804: ,pay_payroll_actions rppa
805: ,per_periods_of_service pps
806: where rppa.payroll_action_id = c_payroll_action_id
807: and pap.person_id between c_start_person and c_end_person
808: and pap.person_id = paa.person_id
809: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_fin_year_end)),1,'Y','N')) LIKE c_employee_type

Line 883: INDEX(pps per_periods_of_service_n3)

879: SELECT /*+ INDEX(pap per_people_f_pk)
880: INDEX(paa per_assignments_f_fk1)
881: INDEX(paa per_assignments_f_N12)
882: INDEX(rppa pay_payroll_actions_pk)
883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id
885: from per_people_f pap
886: ,per_assignments_f paa
887: ,pay_payroll_actions rppa

Line 888: ,per_periods_of_service pps

884: */ distinct paa.assignment_id
885: from per_people_f pap
886: ,per_assignments_f paa
887: ,pay_payroll_actions rppa
888: ,per_periods_of_service pps
889: where rppa.payroll_action_id = c_payroll_action_id
890: and pap.person_id between c_start_person and c_end_person
891: and pap.person_id = paa.person_id
892: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (c_fin_year_end)),1,'Y','N')) LIKE c_employee_type

Line 970: ,per_periods_of_service pps

966: SELECT paa.assignment_id
967: from per_people_f pap
968: ,per_assignments_f paa
969: ,pay_payroll_actions rppa
970: ,per_periods_of_service pps
971: ,pay_population_ranges ppr
972: WHERE rppa.payroll_action_id = c_payroll_action_id
973: AND rppa.payroll_action_id = ppr.payroll_action_id
974: and ppr.payroll_action_id = c_payroll_action_id

Line 1296: per_periods_of_service pps,

1292: -- papf.payroll_name /*Bug 4688800*/
1293: from per_people_f pap,
1294: per_assignments_f paa,
1295: per_grades_tl pgr,
1296: per_periods_of_service pps,
1297: per_pay_bases ppb,
1298: per_pay_proposals pro,
1299: per_assignment_status_types past,
1300: hr_all_organization_units hou,

Line 1376: per_periods_of_service pps,

1372: pps.date_start,
1373: pps.actual_termination_date
1374: from per_people_f pap,
1375: per_assignments_f paf,
1376: per_periods_of_service pps,
1377: pay_assignment_actions paa
1378: where pap.person_id = paf.person_id
1379: and paf.assignment_id = paa.assignment_id
1380: and pps.person_id = pap.person_id