APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on MSC_DEPT_RES_INSTANCES

Line 510: ' msc_dept_res_instances mri, '||

506: ' AND md.origination_type = 1 '||
507: ' ORDER BY 1,4 '||
508: ' ) DETAIL ' ||
509: ' FROM ' ||
510: ' msc_dept_res_instances mri, '||
511: ' msc_department_resources dr '||
512: ' WHERE dr.sr_instance_id = '|| inst_id ||
513: ' AND dr.sr_instance_id = mri.sr_instance_id (+) '||
514: ' AND dr.plan_id = '|| plan_id ||

Line 725: SELECT serial_number FROM Msc_Dept_Res_Instances

721:
722: BEGIN
723: -- B7669553 Select 40 characters for resource_description Rajesh Patangya
724: OPEN cur_resource_inst FOR
725: SELECT serial_number FROM Msc_Dept_Res_Instances
726: WHERE resource_id = p_resource_id
727: AND plan_id = plan_id
728: AND res_instance_id = p_resource_inst
729: AND sr_instance_id = inst_id;