APPS.AHL_COMPLETIONS_PVT dependencies on QA_PLANS_VAL_V

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

5628: SELECT qa.plan_id from qa_results qa
5629: where qa.collection_id = p_collection_id and rownum < 2;
5630:
5631: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
5632: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
5633: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
5634: AND QP.organization_id = p_org_id
5635: AND QPT.transaction_number in (9999,2001)
5636: AND QPCT.collection_trigger_id = 87

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

7839: SELECT qa.plan_id from qa_results qa
7840: where qa.collection_id = p_collection_id and rownum < 2;
7841:
7842: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
7843: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
7844: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
7845: AND QP.organization_id = p_org_id
7846: AND QPT.transaction_number in (9999,2001)
7847: AND QPCT.collection_trigger_id = 87

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

10934: SELECT qa.plan_id from qa_results qa
10935: where qa.collection_id = p_collection_id and rownum < 2;
10936:
10937: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
10938: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
10939: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
10940: AND QP.organization_id = p_org_id
10941: AND QPT.transaction_number in (9999,2001)
10942: AND QPCT.collection_trigger_id = 87