DBA Data[Home] [Help]

APPS.PER_PERCACEI_XMLP_PKG dependencies on FND_SESSIONS

Line 46: INSERT INTO FND_SESSIONS

42: END IF;
43: END IF;
44: END IF;
45: BEGIN
46: INSERT INTO FND_SESSIONS
47: (SESSION_ID
48: ,EFFECTIVE_DATE)
49: SELECT
50: USERENV('sessionid'),

Line 58: FND_SESSIONS FS

54: WHERE not exists (
55: SELECT
56: 1
57: FROM
58: FND_SESSIONS FS
59: WHERE FS.SESSION_ID = USERENV('sessionid')
60: AND FS.EFFECTIVE_DATE = P_ENDING_HIRED_DATE );
61: COMMIT;
62: END;