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_AU_REC_DET_PAYSUM_MODE dependencies on PER_PERIODS_OF_SERVICE

Line 453: INDEX(pps per_periods_of_service_n3)

449: SELECT /*+ INDEX(pap per_people_f_pk)
450: INDEX(paa per_assignments_f_fk1)
451: INDEX(paa per_assignments_f_N12)
452: INDEX(rppa pay_payroll_actions_pk)
453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id
455: from per_people_f pap
456: ,per_assignments_f paa
457: ,pay_payroll_actions rppa

Line 458: ,per_periods_of_service pps

454: */ distinct paa.assignment_id
455: from per_people_f pap
456: ,per_assignments_f paa
457: ,pay_payroll_actions rppa
458: ,per_periods_of_service pps
459: where rppa.payroll_action_id = c_payroll_action_id
460: and pap.person_id between c_start_person and c_end_person
461: and pap.person_id = paa.person_id
462: 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 527: INDEX(pps per_periods_of_service_n3)

523: SELECT /*+ INDEX(pap per_people_f_pk)
524: INDEX(paa per_assignments_f_fk1)
525: INDEX(paa per_assignments_f_N12)
526: INDEX(rppa pay_payroll_actions_pk)
527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id
529: from per_people_f pap
530: ,per_assignments_f paa
531: ,pay_payroll_actions rppa

Line 532: ,per_periods_of_service pps

528: */ distinct paa.assignment_id
529: from per_people_f pap
530: ,per_assignments_f paa
531: ,pay_payroll_actions rppa
532: ,per_periods_of_service pps
533: where rppa.payroll_action_id = c_payroll_action_id
534: and pap.person_id between c_start_person and c_end_person
535: and pap.person_id = paa.person_id
536: 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 605: INDEX(pps per_periods_of_service_PK)

601: SELECT /*+ INDEX(pap per_people_f_pk)
602: INDEX(rppa pay_payroll_actions_pk)
603: INDEX(ppr PAY_POPULATION_RANGES_N4)
604: INDEX(paa per_assignments_f_N12)
605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id
607: from per_people_f pap
608: ,per_assignments_f paa
609: ,pay_payroll_actions rppa

Line 610: ,per_periods_of_service pps

606: */ paa.assignment_id
607: from per_people_f pap
608: ,per_assignments_f paa
609: ,pay_payroll_actions rppa
610: ,per_periods_of_service pps
611: ,pay_population_ranges ppr
612: WHERE rppa.payroll_action_id = c_payroll_action_id
613: AND rppa.payroll_action_id = ppr.payroll_action_id
614: AND ppr.chunk_number = c_chunk

Line 922: per_periods_of_service pps,

918: -- papf.payroll_name /*Bug 4688800*/
919: from per_people_f pap,
920: per_assignments_f paa,
921: per_grades_tl pgr,
922: per_periods_of_service pps,
923: per_pay_bases ppb,
924: per_pay_proposals pro,
925: per_assignment_status_types past,
926: hr_organization_units hou,

Line 1001: per_periods_of_service pps,

997: pps.date_start,
998: pps.actual_termination_date
999: from per_people_f pap,
1000: per_assignments_f paf,
1001: per_periods_of_service pps,
1002: pay_assignment_actions paa
1003: where pap.person_id = paf.person_id
1004: and paf.assignment_id = paa.assignment_id
1005: and pps.person_id = pap.person_id