APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PER_PEOPLE_F

Line 371: ' from per_people_f p,' ||

367: hr_utility.set_location('Start of range_code',1);
368: END if;
369: /* Bug#3043049*/
370: p_sql := ' select distinct p.person_id' ||
371: ' from per_people_f p,' ||
372: ' pay_payroll_actions pa' ||
373: ' where pa.payroll_action_id = :payroll_action_id' ||
374: ' and p.business_group_id = pa.business_group_id' ||
375: ' order by p.person_id';

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

1171: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1172: c_start_person_id in per_all_people_f.person_id%type,
1173: c_end_person_id in per_all_people_f.person_id%type)
1174: is
1175: select /*+ INDEX(p per_people_f_pk)
1176: INDEX(a per_assignments_f_fk1)
1177: INDEX(a per_assignments_f_N12)
1178: INDEX(pa pay_payroll_actions_pk)
1179: INDEX(pps per_periods_of_service_n3)

Line 1181: from per_people_f p /*Bug3043049*/

1177: INDEX(a per_assignments_f_N12)
1178: INDEX(pa pay_payroll_actions_pk)
1179: INDEX(pps per_periods_of_service_n3)
1180: */ distinct a.assignment_id
1181: from per_people_f p /*Bug3043049*/
1182: ,per_assignments_f a /*Bug3043049*/
1183: ,pay_payroll_actions pa
1184: ,per_periods_of_service pps
1185: where pa.payroll_action_id = c_payroll_action_id

Line 1276: from per_people_f p /*Bug3043049*/

1272: c_start_person_id in per_all_people_f.person_id%type,
1273: c_end_person_id in per_all_people_f.person_id%type)
1274: is
1275: select distinct a.assignment_id
1276: from per_people_f p /*Bug3043049*/
1277: ,per_assignments_f a /*Bug3043049*/
1278: ,pay_payroll_actions pa
1279: ,per_periods_of_service pps
1280: where pa.payroll_action_id = c_payroll_action_id

Line 1379: FROM per_people_f p /*Bug3043049*/

1375: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
1376: c_chunk IN NUMBER)
1377: IS
1378: SELECT a.assignment_id
1379: FROM per_people_f p /*Bug3043049*/
1380: ,per_assignments_f a /*Bug3043049*/
1381: ,pay_payroll_actions pa
1382: ,per_periods_of_service pps
1383: ,pay_population_ranges ppr

Line 1515: FROM per_people_f p

1511: CURSOR range_process_assignment_set(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
1512: c_chunk IN NUMBER)
1513: IS
1514: SELECT a.assignment_id
1515: FROM per_people_f p
1516: ,per_assignments_f a
1517: ,pay_payroll_actions pa
1518: ,per_periods_of_service pps
1519: ,pay_population_ranges ppr

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

1607: Cursor process_assignment_set(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1608: c_start_person_id in per_all_people_f.person_id%type,
1609: c_end_person_id in per_all_people_f.person_id%type)
1610: is
1611: select /*+ INDEX(p per_people_f_pk)
1612: INDEX(a per_assignments_f_fk1)
1613: INDEX(a per_assignments_f_N12)
1614: INDEX(pa pay_payroll_actions_pk)
1615: INDEX(pps per_periods_of_service_n3)

Line 1617: from per_people_f p /*Bug3043049*/

1613: INDEX(a per_assignments_f_N12)
1614: INDEX(pa pay_payroll_actions_pk)
1615: INDEX(pps per_periods_of_service_n3)
1616: */ distinct a.assignment_id
1617: from per_people_f p /*Bug3043049*/
1618: ,per_assignments_f a /*Bug3043049*/
1619: ,pay_payroll_actions pa
1620: ,per_periods_of_service pps
1621: ,hr_assignment_set_amendments hasa