DBA Data[Home] [Help]

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'));