DBA Data[Home] [Help]

APPS.QLTCPDFB dependencies on DUAL

Line 54: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;

50:
51: QCAT C1%ROWTYPE;
52:
53: CURSOR CS1 IS
54: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;
55:
56: ACTION_TRIGGER_ID NUMBER;
57:
58: CURSOR C2 IS

Line 81: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;

77:
78: QCA C2%ROWTYPE;
79:
80: CURSOR CS2 IS
81: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;
82:
83: QPC_ACTION_ID NUMBER;
84:
85: -- Bug 3111310. Add app_id to WHERE clause of SQL

Line 138: FROM DUAL;

134: ALR_ACTION_SETS_S.NEXTVAL,
135: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
136: QA_ALR_ACTION_NAME_S.NEXTVAL,
137: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
138: FROM DUAL;
139:
140: NEW_ACTION_ID NUMBER;
141: NEW_ACTION_SET_ID NUMBER;
142: NEW_ACTION_SET_MEMBER_ID NUMBER;