APPS.QLTCPPLB dependencies on ALR_ACTION_SET_MEMBERS

Line 139: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,

135: CURSOR CS3 IS
136: SELECT
137: ALR_ACTIONS_S.NEXTVAL,
138: ALR_ACTION_SETS_S.NEXTVAL,
139: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
140: QA_ALR_ACTION_NAME_S.NEXTVAL,
141: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
142: FROM DUAL;
143:

Line 648: FROM ALR_ACTION_SET_MEMBERS

644:
645: BEGIN
646: SELECT NVL(MAX(SEQUENCE),0)+1
647: INTO ACTION_SET_MEMBERS_SEQUENCE
648: FROM ALR_ACTION_SET_MEMBERS
649: WHERE APPLICATION_ID = 250
650: AND ALERT_ID = 10177
651: AND ACTION_SET_ID = NEW_ACTION_SET_ID;
652: EXCEPTION

Line 657: INSERT INTO ALR_ACTION_SET_MEMBERS (

653: WHEN NO_DATA_FOUND THEN
654: ACTION_SET_MEMBERS_SEQUENCE := 1;
655: END;
656:
657: INSERT INTO ALR_ACTION_SET_MEMBERS (
658: APPLICATION_ID,
659: ACTION_SET_MEMBER_ID,
660: ACTION_SET_ID,
661: ACTION_ID,