APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ASSIGNMENTS_F

Line 2624: select /*+ index(paf PER_ASSIGNMENTS_F_N7)*/

2620:
2621: cursor c_get_organization(cp_payroll_id in number
2622: ,cp_effective_date in date
2623: ) is
2624: select /*+ index(paf PER_ASSIGNMENTS_F_N7)*/
2625: distinct paf.organization_id, -- Bug 3354127
2626: paf.business_group_id
2627: from per_all_assignments_f paf
2628: where paf.payroll_id = cp_payroll_id

Line 2839: from per_assignments_f paf,

2835: paf.time_normal_finish,
2836: paf.business_group_id,
2837: paf.soft_coding_keyflex_id,
2838: paf.hourly_salaried_code
2839: from per_assignments_f paf,
2840: per_all_people_f ppf,
2841: per_all_people_f ppf1,
2842: per_periods_of_service pps
2843: where paf.person_id = ppf.person_id