APPS.GMD_QA_RCV_PUB dependencies on QA_PLANS

Line 304: select plan_id from qa_plans where name = p_plan_name;

300: and rsh.RECEIPT_NUM = p_receipt_num
301: order by rcv.creation_date desc;
302:
303: cursor cur_get_plan_id is
304: select plan_id from qa_plans where name = p_plan_name;
305:
306:
307:
308: l_progress VARCHAR2(3);