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_PAYMENT_SUMMARY dependencies on PER_PEOPLE_F

Line 286: ' from per_people_f p,' ||

282: hr_utility.set_location('Start of range_code',1);
283: END if;
284: /* Bug#3043049*/
285: p_sql := ' select distinct p.person_id' ||
286: ' from per_people_f p,' ||
287: ' pay_payroll_actions pa' ||
288: ' where pa.payroll_action_id = :payroll_action_id' ||
289: ' and p.business_group_id = pa.business_group_id' ||
290: ' order by p.person_id';

Line 690: select /*+ INDEX(p per_people_f_pk)

686: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
687: c_start_person_id in per_all_people_f.person_id%type,
688: c_end_person_id in per_all_people_f.person_id%type)
689: is
690: select /*+ INDEX(p per_people_f_pk)
691: INDEX(a per_assignments_f_fk1)
692: INDEX(a per_assignments_f_N12)
693: INDEX(pa pay_payroll_actions_pk)
694: INDEX(pps per_periods_of_service_n3)

Line 696: from per_people_f p /Bug3043049/

692: INDEX(a per_assignments_f_N12)
693: INDEX(pa pay_payroll_actions_pk)
694: INDEX(pps per_periods_of_service_n3)
695: */ distinct a.assignment_id
696: from per_people_f p /*Bug3043049*/
697: ,per_assignments_f a /*Bug3043049*/
698: ,pay_payroll_actions pa
699: ,per_periods_of_service pps
700: where pa.payroll_action_id = c_payroll_action_id

Line 778: from per_people_f p /Bug3043049/

774: c_start_person_id in per_all_people_f.person_id%type,
775: c_end_person_id in per_all_people_f.person_id%type)
776: is
777: select distinct a.assignment_id
778: from per_people_f p /*Bug3043049*/
779: ,per_assignments_f a /*Bug3043049*/
780: ,pay_payroll_actions pa
781: ,per_periods_of_service pps
782: where pa.payroll_action_id = c_payroll_action_id

Line 866: SELECT /*+ INDEX(pap per_people_f_pk)

862:
863: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
864: c_chunk IN NUMBER)
865: IS
866: SELECT /*+ INDEX(pap per_people_f_pk)
867: INDEX(rppa pay_payroll_actions_pk)
868: INDEX(ppr PAY_POPULATION_RANGES_N4)
869: INDEX(paa per_assignments_f_N12)
870: INDEX(pps per_periods_of_service_PK)

Line 872: FROM per_people_f p /Bug3043049/

868: INDEX(ppr PAY_POPULATION_RANGES_N4)
869: INDEX(paa per_assignments_f_N12)
870: INDEX(pps per_periods_of_service_PK)
871: */ a.assignment_id
872: FROM per_people_f p /*Bug3043049*/
873: ,per_assignments_f a /*Bug3043049*/
874: ,pay_payroll_actions pa
875: ,per_periods_of_service pps
876: ,pay_population_ranges ppr