DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 2627: from per_all_assignments_f paf

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
2629: and cp_effective_date between paf.effective_start_date
2630: and paf.effective_end_date;
2631: