APPS.AHL_COMPLETIONS_PVT dependencies on QA_PLANS_VAL_V

Line 5914: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

5910: SELECT qa.plan_id from qa_results qa
5911: where qa.collection_id = p_collection_id and rownum < 2;
5912:
5913: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
5914: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
5915: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
5916: AND QP.organization_id = p_org_id
5917: AND QPT.transaction_number in (9999,2001)
5918: AND QPCT.collection_trigger_id = 87

Line 8249: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

8245: SELECT qa.plan_id from qa_results qa
8246: where qa.collection_id = p_collection_id and rownum < 2;
8247:
8248: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
8249: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
8250: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
8251: AND QP.organization_id = p_org_id
8252: AND QPT.transaction_number in (9999,2001)
8253: AND QPCT.collection_trigger_id = 87

Line 11793: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT

11789: SELECT qa.plan_id from qa_results qa
11790: where qa.collection_id = p_collection_id and rownum < 2;
11791:
11792: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
11793: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
11794: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
11795: AND QP.organization_id = p_org_id
11796: AND QPT.transaction_number in (9999,2001)
11797: AND QPCT.collection_trigger_id = 87