APPS.QLTTRAWB dependencies on QA_PLANS_VAL_V

Line 5442: FROM QA_PLANS_VAL_V QPVV

5438: QRI.TRANSACTION_INTERFACE_ID
5439: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5440: AND NOT EXISTS
5441: (SELECT 'X'
5442: FROM QA_PLANS_VAL_V QPVV
5443: WHERE QRI.PLAN_NAME = QPVV.NAME
5444: AND QRI.ORGANIZATION_ID = QPVV.ORGANIZATION_ID);
5445:
5446: If (sql%rowcount >0) THEN

Line 5461: FROM QA_PLANS_VAL_V QPVV

5457: PROGRAM_ID = X_PROGRAM_ID,
5458: PROGRAM_UPDATE_DATE = SYSDATE,
5459: PLAN_ID =
5460: (SELECT MIN(QPVV.PLAN_ID)
5461: FROM QA_PLANS_VAL_V QPVV
5462: WHERE QPVV.NAME = QRI.PLAN_NAME
5463: AND QPVV.ORGANIZATION_ID = QRI.ORGANIZATION_ID)
5464: WHERE QRI.GROUP_ID = X_GROUP_ID
5465: AND QRI.PROCESS_STATUS = 2