DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on PER_ASSIGNMENTS_F

Line 921: from per_assignments_f paf,

917: and pap.effective_end_date
918: and pap.benefit_group_id = p_benfts_grp_id))
919: and (p_legal_entity_id is null
920: or exists (select null
921: from per_assignments_f paf,
922: hr_soft_coding_keyflex soft
923: where paf.person_id = ppf.person_id
924: and paf.assignment_type <> 'C'
925: and l_effective_date