APPS.QLTCPPLB dependencies on QA_PLAN_CHAR_ACTIONS

Line 70: FROM QA_PLAN_CHAR_ACTIONS

66: ALR_ACTION_ID,
67: ALR_ACTION_SET_ID,
68: ASSIGNED_CHAR_ID,
69: ASSIGN_TYPE
70: FROM QA_PLAN_CHAR_ACTIONS
71: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID
72: ORDER BY PLAN_CHAR_ACTION_ID;
73:
74: QPCA C2%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 463: INSERT INTO QA_PLAN_CHAR_ACTIONS (

459:
460: NEW_ACTION_NAME := 'QA_' || TO_CHAR(X_ACTION_NAME);
461: NEW_ACTION_SET_NAME := 'QA_' || TO_CHAR(X_ACTION_SET_NAME);
462:
463: INSERT INTO QA_PLAN_CHAR_ACTIONS (
464: PLAN_CHAR_ACTION_ID,
465: LAST_UPDATE_DATE,
466: LAST_UPDATED_BY,
467: CREATION_DATE,