APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on HR_SOFT_CODING_KEYFLEX
Line 852: from hr_soft_coding_keyflex hsc,
848: and l_effective_date
849: between asg.effective_start_date and asg.effective_end_date))
850: and (( p_legal_entity_id is null )
851: or exists (select null 852: from hr_soft_coding_keyflex hsc, 853: per_all_assignments_f asg
854: where asg.person_id = pil.person_id
855: and asg.assignment_type <> 'C'
856: and asg.primary_flag = 'Y'