DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CONC dependencies on PER_ALL_ASSIGNMENTS_F

Line 492: from per_all_assignments_f paa

488: and (p_person_id is null or
489: ppf.person_id = p_person_id)
490: and (p_organization_id is null
491: or exists (select null
492: from per_all_assignments_f paa
493: where paa.person_id = ppf.person_id
494: and l_effective_date
495: between paa.effective_start_date
496: and paa.effective_end_date

Line 502: from per_all_assignments_f paa

498: and paa.primary_flag = 'Y'
499: and paa.organization_id = p_organization_id))
500: and (p_location_id is null
501: or exists (select null
502: from per_all_assignments_f paa
503: where paa.person_id = ppf.person_id
504: and l_effective_date
505: between paa.effective_start_date
506: and paa.effective_end_date