APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on MSC_DEPARTMENT_RESOURCES

Line 419: ' msc_department_resources dr '||

415: ' ORDER BY 1,4 '||
416: ' ) DETAIL ' ||
417: ' FROM ' ||
418: ' msc_dept_res_instances mri, '||
419: ' msc_department_resources dr '||
420: ' WHERE dr.sr_instance_id = '|| inst_id ||
421: ' AND dr.sr_instance_id = mri.sr_instance_id (+) '||
422: ' AND dr.plan_id = '|| plan_id ||
423: ' AND dr.plan_id = mri.plan_id (+)'||

Line 561: SELECT distinct substr(resource_description,1,16) FROM msc_department_resources

557: l_resource VARCHAR2(16);
558:
559: BEGIN
560: OPEN cur_res_desc FOR
561: SELECT distinct substr(resource_description,1,16) FROM msc_department_resources
562: WHERE plan_id = plan_id
563: AND resource_id = p_resource_id
564: AND sr_instance_id = inst_id;
565: