APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on FND_GLOBAL

Line 106: l_user_id NUMBER := fnd_global.user_id;

102: PROCEDURE Incremental_Update IS
103: --
104: l_sql_stmt VARCHAR2(2000);
105: l_current_time DATE := SYSDATE;
106: l_user_id NUMBER := fnd_global.user_id;
107: l_effective_date DATE := TRUNC(SYSDATE);
108: l_business_group_id NUMBER(15) := g_business_group_id;
109: l_login_id NUMBER := fnd_global.login_id;
110: --

Line 109: l_login_id NUMBER := fnd_global.login_id;

105: l_current_time DATE := SYSDATE;
106: l_user_id NUMBER := fnd_global.user_id;
107: l_effective_date DATE := TRUNC(SYSDATE);
108: l_business_group_id NUMBER(15) := g_business_group_id;
109: l_login_id NUMBER := fnd_global.login_id;
110: --
111: CURSOR c_pgm IS
112: SELECT pgm.pgm_id pgm_id
113: FROM ben_pgm_f pgm

Line 621: l_user_id NUMBER := fnd_global.user_id;

617: l_sql_stmt VARCHAR2(2000);
618: l_current_time DATE := SYSDATE;
619: l_effective_date DATE := TRUNC(SYSDATE);
620: l_business_group_id NUMBER(15) := g_business_group_id;
621: l_user_id NUMBER := fnd_global.user_id;
622: l_login_id NUMBER := fnd_global.login_id;
623: --
624: CURSOR c_pgm IS
625: SELECT pgm.pgm_id PGM_ID

Line 622: l_login_id NUMBER := fnd_global.login_id;

618: l_current_time DATE := SYSDATE;
619: l_effective_date DATE := TRUNC(SYSDATE);
620: l_business_group_id NUMBER(15) := g_business_group_id;
621: l_user_id NUMBER := fnd_global.user_id;
622: l_login_id NUMBER := fnd_global.login_id;
623: --
624: CURSOR c_pgm IS
625: SELECT pgm.pgm_id PGM_ID
626: FROM ben_pgm_f pgm