APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ASSIGNMENTS_F

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

2517:
2518: cursor c_get_organization(cp_payroll_id in number
2519: ,cp_effective_date in date
2520: ) is
2521: select /*+ index(paf PER_ASSIGNMENTS_F_N7)*/
2522: distinct paf.organization_id, -- Bug 3354127
2523: paf.business_group_id
2524: from per_all_assignments_f paf
2525: where paf.payroll_id = cp_payroll_id

Line 2735: from per_assignments_f paf,

2731: paf.time_normal_finish,
2732: paf.business_group_id,
2733: paf.soft_coding_keyflex_id,
2734: paf.hourly_salaried_code
2735: from per_assignments_f paf,
2736: per_all_people_f ppf,
2737: per_periods_of_service pps
2738: where paf.person_id = ppf.person_id
2739: and paf.assignment_id = cp_assignment_id