DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on PER_ALL_ASSIGNMENTS_F

Line 851: from per_all_assignments_f paa

847: )
848: -- Bug 2547536 -- and pil.business_group_id = ppf.business_group_id)
849: and (p_organization_id is null
850: or exists (select null
851: from per_all_assignments_f paa
852: where paa.person_id = ppf.person_id
853: and l_effective_date
854: between paa.effective_start_date
855: and paa.effective_end_date

Line 861: from per_all_assignments_f paa

857: and paa.primary_flag = 'Y'
858: and paa.organization_id = p_organization_id))
859: and (p_location_id is null
860: or exists (select null
861: from per_all_assignments_f paa
862: where paa.person_id = ppf.person_id
863: and l_effective_date
864: between paa.effective_start_date
865: and paa.effective_end_date