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: (