DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on PER_ASSIGNMENTS_F

Line 1885: from per_assignments_f asg

1881: and (p_person_id is null or
1882: pen.person_id = p_person_id)
1883: and (p_location_id is null or
1884: exists ( select null
1885: from per_assignments_f asg
1886: where asg.person_id = pen.person_id
1887: and asg.assignment_type <> 'C'
1888: and asg.location_id = p_location_id
1889: and asg.business_group_id = p_business_group_id