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 3631: l_username fnd_user.user_name%TYPE;

3627: Procedure chk_secure_event_flag (p_organization_id in number)
3628: IS
3629:
3630: l_proc varchar2(72) := g_package||'chk_secure_event_flag';
3631: l_username fnd_user.user_name%TYPE;
3632: l_user fnd_user.user_name%TYPE;
3633: l_condition boolean;
3634:
3635: CURSOR csr_org IS

Line 3632: l_user fnd_user.user_name%TYPE;

3628: IS
3629:
3630: l_proc varchar2(72) := g_package||'chk_secure_event_flag';
3631: l_username fnd_user.user_name%TYPE;
3632: l_user fnd_user.user_name%TYPE;
3633: l_condition boolean;
3634:
3635: CURSOR csr_org IS
3636: SELECT user_name

Line 3637: FROM fnd_user f,

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