DBA Data[Home] [Help]

APPS.OTA_EVT_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 3618: per_all_assignments_f p

3614:
3615: CURSOR csr_org IS
3616: SELECT user_name
3617: FROM fnd_user f,
3618: per_all_assignments_f p
3619: WHERE p.organization_id = p_organization_id
3620: AND f.employee_id = p.person_id
3621: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3622: AND f.user_id = to_number(fnd_profile.value('USER_ID'));