APPS.PAY_AU_RECON_SUMMARY dependencies on PER_PEOPLE_F

Line 1593: ' from per_people_f p,' ||

1589: IF g_debug THEN
1590: hr_utility.set_location('Start of range_code',1);
1591: END if;
1592: p_sql := ' select distinct p.person_id' ||
1593: ' from per_people_f p,' ||
1594: ' pay_payroll_actions pa' ||
1595: ' where pa.payroll_action_id = :payroll_action_id' ||
1596: ' and p.business_group_id = pa.business_group_id' ||
1597: ' order by p.person_id';

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

1762: p_fbt_year_end date,
1763: p_lst_year_start date
1764: )
1765: is
1766: SELECT /*+ INDEX(pap per_people_f_pk)
1767: INDEX(rppa pay_payroll_actions_pk)
1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id

Line 1771: from per_people_f pap

1767: INDEX(rppa pay_payroll_actions_pk)
1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa
1773: ,pay_payroll_actions rppa
1774: ,per_periods_of_service pps
1775: where rppa.payroll_action_id = p_payroll_action_id

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

1839: p_fbt_year_end date,
1840: p_lst_year_start date
1841: )
1842: IS
1843: SELECT /*+ INDEX(pap per_people_f_pk)
1844: INDEX(rppa pay_payroll_actions_pk)
1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)

Line 1849: from per_people_f pap

1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa
1852: ,per_periods_of_service pps
1853: ,pay_population_ranges ppr

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

1910: p_fbt_year_end date,
1911: p_lst_year_start date
1912: )
1913: is
1914: SELECT /*+ INDEX(pap per_people_f_pk)
1915: INDEX(paa per_assignments_f_fk1)
1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)

Line 1920: from per_people_f pap

1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa
1922: ,pay_payroll_actions rppa
1923: ,per_periods_of_service pps
1924: where rppa.payroll_action_id = p_payroll_action_id