APPS.OTA_EVT_BUS dependencies on PER_ALL_ASSIGNMENTS_F
Line 3638: per_all_assignments_f p
3634:
3635: CURSOR csr_org IS
3636: SELECT user_name
3637: FROM fnd_user f, 3638: per_all_assignments_f p 3639: WHERE p.organization_id = p_organization_id
3640: AND f.employee_id = p.person_id
3641: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3642: AND f.user_id = to_number(fnd_profile.value('USER_ID'));