DBA Data[Home] [Help]

APPS.CSM_NEW_MESSAGES_EVENT_PKG dependencies on CSM_NEW_MESSAGES_ACC_S

Line 337: SELECT CSM_NEW_MESSAGES_ACC_S.NEXTVAL

333: WHERE ACC.MESSAGE_ID = CNMT.MESSAGE_ID
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: (

Line 579: SELECT CSM_NEW_MESSAGES_ACC_S.NEXTVAL

575: (CNMP.LEVEL_ID=10004
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: (