DBA Data[Home] [Help]

APPS.QLTTRAWB dependencies on QA_PLANS_VAL_V

Line 5094: FROM QA_PLANS_VAL_V QPVV

5090: QRI.TRANSACTION_INTERFACE_ID
5091: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5092: AND NOT EXISTS
5093: (SELECT 'X'
5094: FROM QA_PLANS_VAL_V QPVV
5095: WHERE QRI.PLAN_NAME = QPVV.NAME
5096: AND QRI.ORGANIZATION_ID = QPVV.ORGANIZATION_ID);
5097:
5098: -- group derivation for plan_id

Line 5109: FROM QA_PLANS_VAL_V QPVV

5105: PROGRAM_ID = X_PROGRAM_ID,
5106: PROGRAM_UPDATE_DATE = SYSDATE,
5107: PLAN_ID =
5108: (SELECT MIN(QPVV.PLAN_ID)
5109: FROM QA_PLANS_VAL_V QPVV
5110: WHERE QPVV.NAME = QRI.PLAN_NAME
5111: AND QPVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID)
5112: WHERE QRI.GROUP_ID = X_GROUP_ID
5113: AND QRI.PROCESS_STATUS = 2