APPS.QLTCPPLB dependencies on ALR_ACTION_SETS

Line 130: ALR_ACTION_SETS_S.NEXTVAL,

126:
127: CURSOR CS3 IS
128: SELECT
129: ALR_ACTIONS_S.NEXTVAL,
130: ALR_ACTION_SETS_S.NEXTVAL,
131: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
132: QA_ALR_ACTION_NAME_S.NEXTVAL,
133: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
134: FROM DUAL;

Line 586: FROM ALR_ACTION_SETS

582:
583: BEGIN
584: SELECT NVL(MAX(SEQUENCE),0)+1
585: INTO ACTION_SET_SEQUENCE
586: FROM ALR_ACTION_SETS
587: WHERE APPLICATION_ID = 250
588: AND ALERT_ID = 10177;
589:
590: EXCEPTION

Line 595: INSERT INTO ALR_ACTION_SETS (

591: WHEN NO_DATA_FOUND THEN
592: ACTION_SET_SEQUENCE := 1;
593: END;
594:
595: INSERT INTO ALR_ACTION_SETS (
596: APPLICATION_ID,
597: ACTION_SET_ID,
598: NAME,
599: ALERT_ID,