DBA Data[Home] [Help]

APPS.GMO_OC_TRANS_PKG dependencies on MTL_PARAMETERS

Line 29: mtl_parameters mp

25: l_operator_name VARCHAR2(240);
26: CURSOR GET_ORG_NAME IS
27: SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE
28: FROM hr_all_organization_units hou,
29: mtl_parameters mp
30: WHERE hou.organization_id = Plant
31: AND NVL(hou.date_to, SYSDATE+1) >= SYSDATE
32: and mp.organization_id = hou.organization_id;
33: CURSOR GET_OBJECT_TYPE(ob_type_id NUMBER) IS