eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EVT_BUS dependencies on FND_USER

Line 3611: l_username fnd_user.user_name%TYPE;

3607: Procedure chk_secure_event_flag (p_organization_id in number)
3608: IS
3609:
3610: l_proc varchar2(72) := g_package||'chk_secure_event_flag';
3611: l_username fnd_user.user_name%TYPE;
3612: l_user fnd_user.user_name%TYPE;
3613: l_condition boolean;
3614:
3615: CURSOR csr_org IS

Line 3612: l_user fnd_user.user_name%TYPE;

3608: IS
3609:
3610: l_proc varchar2(72) := g_package||'chk_secure_event_flag';
3611: l_username fnd_user.user_name%TYPE;
3612: l_user fnd_user.user_name%TYPE;
3613: l_condition boolean;
3614:
3615: CURSOR csr_org IS
3616: SELECT user_name

Line 3617: FROM fnd_user f,

3613: l_condition boolean;
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