APPS.GMO_OC_TRANS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 28: FROM hr_all_organization_units hou,

24: l_object VARCHAR2(240);
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;