DBA Data[Home] [Help]

APPS.CSM_NEW_MESSAGES_EVENT_PKG dependencies on DUAL

Line 338: FROM DUAL;

334: AND ACC.USER_ID = AU.USER_ID);
335:
336: CURSOR C_GET_ACCESS_ID IS
337: SELECT CSM_NEW_MESSAGES_ACC_S.NEXTVAL
338: FROM DUAL;
339:
340: TYPE con_rec_type IS RECORD
341: (
342: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,

Line 580: FROM DUAL;

576: AND CNMP.LEVEL_VALUE=AU.USER_ID)));
577:
578: CURSOR C_GET_ACCESS_ID IS
579: SELECT CSM_NEW_MESSAGES_ACC_S.NEXTVAL
580: FROM DUAL;
581:
582: TYPE con_rec_type IS RECORD
583: (
584: MESSAGE_ID CSM_NEW_MESSAGES.MESSAGE_ID%TYPE,