DBA Data[Home] [Help]

APPS.BEN_PREMIUM_CONCURRENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 579: or exists (select null from per_all_assignments_f

575: and pen.business_group_id+0 = p_business_group_id
576: and p_effective_date between
577: pen.effective_start_date and pen.effective_end_date
578: and (p_organization_id is null
579: or exists (select null from per_all_assignments_f
580: where person_id = pen.person_id
581: and business_group_id = p_business_group_id
582: and p_effective_date between nvl(effective_start_date,p_effective_date )
583: and nvl(effective_end_date, p_effective_date )