DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 3351: FROM per_all_assignments_f

3347: IS
3348:
3349: CURSOR csr_person_orgs IS
3350: SELECT NULL
3351: FROM per_all_assignments_f
3352: WHERE person_id = p_person_id
3353: AND trunc(sysdate) between effective_start_date and effective_end_date
3354: AND organization_id = p_sponsor_org_id
3355: AND assignment_type in ('E', 'C', 'A');