DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on QA_PLANS

Line 139: FROM QA_PLANS

135:
136: BEGIN
137: SELECT organization_id
138: INTO l_organization_id
139: FROM QA_PLANS
140: WHERE plan_id = p_plan_id;
141:
142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN

Line 1007: FROM QA_PLANS_VAL_V QP,

1003: BEGIN
1004:
1005: SELECT QP.plan_id
1006: INTO x_plan_id
1007: FROM QA_PLANS_VAL_V QP,
1008: QA_PLAN_TRANSACTIONS QPT,
1009: QA_PLAN_COLLECTION_TRIGGERS QPCT
1010: WHERE QP.plan_id = QPT.plan_id
1011: AND QPT.plan_transaction_id = QPCT.plan_transaction_id