APPS.JL_ZZ_AUTO_INVOICE dependencies on HR_ORGANIZATION_UNITS

Line 66: FROM hr_organization_units hou,

62: l_dummy_code := NULL;
63: BEGIN
64: SELECT 'Success'
65: INTO l_dummy_code
66: FROM hr_organization_units hou,
67: hr_locations_all hl
68: WHERE hou.organization_id = p_warehouse_id
69: AND hl.location_id = hou.location_id
70: AND hl.global_attribute1 IS NOT NULL;