DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on QA_PLAN_COLLECTION_TRIGGERS

Line 609: QA_PLAN_COLLECTION_TRIGGERS QPCT

605: CURSOR get_MRB_Quality_csr(c_org_id NUMBER) IS
606: SELECT QP.plan_id
607: FROM QA_PLANS_VAL_V QP,
608: QA_PLAN_TRANSACTIONS QPT,
609: QA_PLAN_COLLECTION_TRIGGERS QPCT
610: WHERE QP.plan_id = QPT.plan_id
611: AND QPT.plan_transaction_id = QPCT.plan_transaction_id
612: AND QP.organization_id = c_org_id
613: AND QPT.transaction_number = 2004 -- MRB_TRANSACTION_NUMBER