APPS.PAY_AU_RECON_SUMMARY dependencies on PER_PEOPLE_F

Line 2809: ' from per_people_f p,' ||

2805: IF g_debug THEN
2806: hr_utility.set_location('Start of range_code',1);
2807: END if;
2808: p_sql := ' select distinct p.person_id' ||
2809: ' from per_people_f p,' ||
2810: ' pay_payroll_actions pa' ||
2811: ' where pa.payroll_action_id = :payroll_action_id' ||
2812: ' and p.business_group_id = pa.business_group_id' ||
2813: ' order by p.person_id';

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

2978: p_fbt_year_end date,
2979: p_lst_year_start date
2980: )
2981: is
2982: SELECT /*+ INDEX(pap per_people_f_pk)
2983: INDEX(rppa pay_payroll_actions_pk)
2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id

Line 2987: from per_people_f pap

2983: INDEX(rppa pay_payroll_actions_pk)
2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa
2989: ,pay_payroll_actions rppa
2990: ,per_periods_of_service pps
2991: where rppa.payroll_action_id = p_payroll_action_id

Line 3070: from per_people_f pap

3066: p_lst_year_start date
3067: )
3068: IS
3069: SELECT paa.assignment_id
3070: from per_people_f pap
3071: ,per_assignments_f paa
3072: ,pay_payroll_actions rppa
3073: ,per_periods_of_service pps
3074: ,pay_population_ranges ppr

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

3142: p_fbt_year_end date,
3143: p_lst_year_start date
3144: )
3145: is
3146: SELECT /*+ INDEX(pap per_people_f_pk)
3147: INDEX(paa per_assignments_f_fk1)
3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)

Line 3152: from per_people_f pap

3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa
3154: ,pay_payroll_actions rppa
3155: ,per_periods_of_service pps
3156: where rppa.payroll_action_id = p_payroll_action_id