APPS.QLTCPPLB dependencies on DUAL

Line 46: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;

42: PLAN_CHAR_ACTION_TRIGGER_ID;
43:
44:
45: CURSOR CS1 IS
46: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;
47:
48: ACTION_TRIGGER_ID NUMBER;
49:
50: QPCAT C1%ROWTYPE;

Line 85: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;

81:
82: QPCA C2%ROWTYPE;
83:
84: CURSOR CS2 IS
85: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;
86:
87: QPC_ACTION_ID NUMBER;
88:
89: -- Bug 3111310. Add app_id to WHERE clause of SQL

Line 142: FROM DUAL;

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:
144: NEW_ACTION_ID NUMBER;
145: NEW_ACTION_SET_ID NUMBER;
146: NEW_ACTION_SET_MEMBER_ID NUMBER;