DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on PER_ASSIGNMENTS_F

Line 1745: from per_assignments_f asg

1741: and (p_person_id is null or
1742: pen.person_id = p_person_id)
1743: and (p_location_id is null or
1744: exists ( select null
1745: from per_assignments_f asg
1746: where asg.person_id = pen.person_id
1747: and asg.assignment_type <> 'C'
1748: and asg.location_id = p_location_id
1749: and asg.business_group_id = p_business_group_id