DBA Data[Home] [Help]

APPS.QA_MQA_MWA_API dependencies on QA_PLANS

Line 203: FROM qa_plan_transactions qpt, qa_plans qp

199: element_ids CtxElemIdTab;
200:
201: CURSOR AvailablePlans(txn_number NUMBER, orgID NUMBER) IS
202: SELECT qpt.plan_transaction_id, qp.plan_id
203: FROM qa_plan_transactions qpt, qa_plans qp
204: WHERE qpt.transaction_number = txn_number
205: AND qpt.plan_id = qp.plan_id
206: AND qp.organization_id = orgID
207: AND qpt.enabled_flag = 1;