DBA Data[Home] [Help]

APPS.PAY_PAYGBP45_A4_PKG dependencies on FND_SESSIONS

Line 35: INSERT INTO FND_SESSIONS

31: L_TEST NUMBER;
32: L_ERS_ADDRESS VARCHAR2(60);
33: BEGIN
34: --HR_STANDARD.EVENT('BEFORE REPORT');
35: INSERT INTO FND_SESSIONS
36: (SESSION_ID
37: ,EFFECTIVE_DATE)
38: SELECT
39: USERENV('sessionid'),

Line 47: FND_SESSIONS FS

43: WHERE not exists (
44: SELECT
45: 1
46: FROM
47: FND_SESSIONS FS
48: WHERE FS.SESSION_ID = USERENV('sessionid') );
49: P_SESSION_DATE := SYSDATE;
50: P_DATE_TODAY := SYSDATE;
51: IF P_ASSIGNMENT_ACTION_ID IS NULL THEN