APPS.QLTCPPLB dependencies on QA_PLAN_CHAR_ACTIONS

Line 78: FROM QA_PLAN_CHAR_ACTIONS

74: ALR_ACTION_SET_ID,
75: ASSIGNED_CHAR_ID,
76: ASSIGN_TYPE,
77: STATUS_ID
78: FROM QA_PLAN_CHAR_ACTIONS
79: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID
80: ORDER BY PLAN_CHAR_ACTION_ID;
81:
82: QPCA C2%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 477: INSERT INTO QA_PLAN_CHAR_ACTIONS (

473: -- Insert the status_id fetched from the cursor
474: -- hmakam
475: --
476:
477: INSERT INTO QA_PLAN_CHAR_ACTIONS (
478: PLAN_CHAR_ACTION_ID,
479: LAST_UPDATE_DATE,
480: LAST_UPDATED_BY,
481: CREATION_DATE,