APPS.GHR_ELT_TO_BEN_PKG dependencies on FND_SESSIONS
Line 476: UPDATE fnd_sessions SET SESSION_ID = l_sid
472: EXIT;
473: END LOOP;
474:
475: BEGIN 476: UPDATE fnd_sessions SET SESSION_ID = l_sid 477: WHERE SESSION_ID = l_sid;
478: IF SQL%NOTFOUND THEN
479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
480: VALUES (l_sid,sysdate);
Line 479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
475: BEGIN
476: UPDATE fnd_sessions SET SESSION_ID = l_sid
477: WHERE SESSION_ID = l_sid;
478: IF SQL%NOTFOUND THEN 479: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE) 480: VALUES (l_sid,sysdate);
481: END IF;
482: END;
483: