DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 3139: per_all_assignments_f asg

3135: SELECT person_id
3136: INTO l_person_id
3137: FROM (SELECT person.person_id
3138: FROM per_all_people_f person,
3139: per_all_assignments_f asg
3140: WHERE asg.position_id = l_orig_system_id
3141: AND TRUNC (SYSDATE)
3142: BETWEEN person.effective_start_date
3143: AND NVL