APPS.GMO_MBR_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 149: FROM hr_all_organization_units hou, mtl_parameters mp

145: to_number(instr(P_MBR_EVT_KEY,'-',1,2))-to_number(instr(P_MBR_EVT_KEY,'-'))-1))
146: into l_org_id from dual;
147:
148: SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE into X_ORG_NAME,X_ORG_CODE
149: FROM hr_all_organization_units hou, mtl_parameters mp
150: WHERE hou.organization_id = l_org_id
151: and mp.organization_id = hou.organization_id;
152: END get_organization;
153: