DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on QA_PLANS

Line 143: FROM QA_PLANS

139:
140: BEGIN
141: SELECT organization_id
142: INTO l_organization_id
143: FROM QA_PLANS
144: WHERE plan_id = p_plan_id;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN

Line 1027: FROM QA_PLANS_VAL_V QP,

1023: BEGIN
1024:
1025: SELECT QP.plan_id
1026: INTO x_plan_id
1027: FROM QA_PLANS_VAL_V QP,
1028: QA_PLAN_TRANSACTIONS QPT,
1029: QA_PLAN_COLLECTION_TRIGGERS QPCT
1030: WHERE QP.plan_id = QPT.plan_id
1031: AND QPT.plan_transaction_id = QPCT.plan_transaction_id