DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 3268: FROM per_all_assignments_f

3264: IS
3265:
3266: CURSOR csr_person_orgs IS
3267: SELECT NULL
3268: FROM per_all_assignments_f
3269: WHERE person_id = p_person_id
3270: AND trunc(sysdate) between effective_start_date and effective_end_date
3271: AND organization_id = p_sponsor_org_id
3272: AND assignment_type in ('E', 'C', 'A');