DBA Data[Home] [Help]

APPS.GMP_DESPATCH_LOAD_RPT_PKG dependencies on MTL_PARAMETERS

Line 248: ' mtl_parameters mp, ' ||

244: ' and gri.instance_id (+) = gi.instance_id '||
245: ' order by 1,2,4 '||
246: ' ) DETAIL ' ||
247: ' FROM ' ||
248: ' mtl_parameters mp, ' ||
249: ' hr_organization_units hr, ' ||
250: ' cr_rsrc_dtl crd, ' ||
251: ' gmp_resource_instances gi '||
252: ' WHERE mp.organization_id = hr.organization_id '||

Line 474: SELECT organization_code FROM mtl_parameters

470: l_orgn_code VARCHAR2(3);
471:
472: BEGIN
473: OPEN cur_orgn_code FOR
474: SELECT organization_code FROM mtl_parameters
475: WHERE organization_id = p_orgn_id;
476:
477: FETCH cur_orgn_code INTO l_orgn_code ;
478: