DBA Data[Home] [Help]

APPS.GMO_DISP_CON_PKG dependencies on MTL_PARAMETERS

Line 45: mtl_parameters mp

41: l_org_code VARCHAR2(240);
42: CURSOR GET_ORG_NAME IS
43: SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE
44: FROM hr_all_organization_units hou,
45: mtl_parameters mp
46: WHERE hou.organization_id = Plant
47: AND NVL(hou.date_to, SYSDATE+1) >= SYSDATE
48: and mp.organization_id = hou.organization_id;
49:

Line 222: mtl_parameters mp

218: l_org_code VARCHAR2(240);
219: CURSOR GET_ORG_NAME IS
220: SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE
221: FROM hr_all_organization_units hou,
222: mtl_parameters mp
223: WHERE hou.organization_id = Plant
224: AND NVL(hou.date_to, SYSDATE+1) >= SYSDATE
225: and mp.organization_id = hou.organization_id;
226: