DBA Data[Home] [Help]

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 77: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;

73:
74: QPCA C2%ROWTYPE;
75:
76: CURSOR CS2 IS
77: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;
78:
79: QPC_ACTION_ID NUMBER;
80:
81: -- Bug 3111310. Add app_id to WHERE clause of SQL

Line 134: FROM DUAL;

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;
135:
136: NEW_ACTION_ID NUMBER;
137: NEW_ACTION_SET_ID NUMBER;
138: NEW_ACTION_SET_MEMBER_ID NUMBER;