APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1411: FROM hr_organization_units hr,

1407: END IF;
1408: IF p_delivery_id IS NOT NULL THEN
1409: SELECT hr.name
1410: INTO cp_warehouse_name
1411: FROM hr_organization_units hr,
1412: wsh_new_deliveries del
1413: WHERE del.organization_id = hr.organization_id
1414: AND del.delivery_id = p_delivery_id;
1415: ELSIF p_organization_id IS NOT NULL

Line 1419: FROM hr_organization_units

1415: ELSIF p_organization_id IS NOT NULL
1416: THEN
1417: SELECT name
1418: INTO cp_warehouse_name
1419: FROM hr_organization_units
1420: WHERE organization_id=p_organization_id;
1421: p_organizationid_1:='AND det.organization_id = :p_organization_id';
1422: ELSE
1423: NULL;