DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 2524: from per_all_assignments_f paf

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
2526: and cp_effective_date between paf.effective_start_date
2527: and paf.effective_end_date;
2528: