DBA Data[Home] [Help]

APPS.PAY_PAYGBP45_XMLP_PKG dependencies on FND_SESSIONS

Line 10: INSERT INTO FND_SESSIONS

6: L_TEST NUMBER;
7: L_ERS_ADDRESS VARCHAR2(60);
8: BEGIN
9: --HR_STANDARD.EVENT('BEFORE REPORT');
10: INSERT INTO FND_SESSIONS
11: (SESSION_ID
12: ,EFFECTIVE_DATE)
13: SELECT
14: USERENV('sessionid'),

Line 22: FND_SESSIONS FS

18: WHERE not exists (
19: SELECT
20: 1
21: FROM
22: FND_SESSIONS FS
23: WHERE FS.SESSION_ID = USERENV('sessionid') );
24: P_SESSION_DATE := SYSDATE;
25: P_DATE_TODAY := SYSDATE;
26: IF P_ASSIGNMENT_ACTION_ID IS NULL THEN