APPS.GMO_DISP_CON_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 44: FROM hr_all_organization_units hou,

40: l_org_name VARCHAR2(4000);
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;

Line 221: FROM hr_all_organization_units hou,

217: l_org_name VARCHAR2(4000);
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;