DBA Data[Home] [Help]

APPS.SSP_SSPRPSPA_XMLP_PKG dependencies on FND_SESSIONS

Line 13: INSERT INTO FND_SESSIONS

9: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
10: AA_P_DATE_FROM:=to_char(P_DATE_FROM,'DD-MON-YYYY');
11: AA_P_DATE_TO:=to_char(P_DATE_TO,'DD-MON-YYYY');
12: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
13: INSERT INTO FND_SESSIONS
14: (SESSION_ID
15: ,EFFECTIVE_DATE)
16: SELECT
17: USERENV('sessionid'),

Line 25: FND_SESSIONS FS

21: WHERE not exists (
22: SELECT
23: 1
24: FROM
25: FND_SESSIONS FS
26: WHERE FS.SESSION_ID = USERENV('sessionid') );
27: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
28: IF P_PAYROLL_ID IS NOT NULL THEN
29: SELECT