APPS.AHL_FMP_MR_ACTION_PVT dependencies on QA_PLANS

Line 253: FROM QA_PLANS

249:
250: CURSOR get_planid_frm_name(c_plan_name VARCHAR2)
251: IS
252: SELECT plan_id
253: FROM QA_PLANS
254: WHERE upper(name)=upper(c_plan_name)
255: AND sysdate between EFFECTIVE_FROM
256: AND nvl(EFFECTIVE_TO,sysdate);
257: BEGIN