DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on PER_ALL_ASSIGNMENTS_F

Line 825: from per_all_assignments_f paa

821: )
822: -- Bug 2547536 -- and pil.business_group_id = ppf.business_group_id)
823: and (p_organization_id is null
824: or exists (select null
825: from per_all_assignments_f paa
826: where paa.person_id = ppf.person_id
827: and l_effective_date
828: between paa.effective_start_date
829: and paa.effective_end_date

Line 835: from per_all_assignments_f paa

831: and paa.primary_flag = 'Y'
832: and paa.organization_id = p_organization_id))
833: and (p_location_id is null
834: or exists (select null
835: from per_all_assignments_f paa
836: where paa.person_id = ppf.person_id
837: and l_effective_date
838: between paa.effective_start_date
839: and paa.effective_end_date