APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1648: FROM hr_organization_units hr,

1644: END IF;
1645: IF p_delivery_id IS NOT NULL THEN
1646: SELECT hr.name
1647: INTO cp_warehouse_name
1648: FROM hr_organization_units hr,
1649: wsh_new_deliveries del
1650: WHERE del.organization_id = hr.organization_id
1651: AND del.delivery_id = p_delivery_id;
1652: ELSIF p_organization_id IS NOT NULL

Line 1656: FROM hr_organization_units

1652: ELSIF p_organization_id IS NOT NULL
1653: THEN
1654: SELECT name
1655: INTO cp_warehouse_name
1656: FROM hr_organization_units
1657: WHERE organization_id=p_organization_id;
1658: p_organizationid_1:='AND det.organization_id = :p_organization_id';
1659: ELSE
1660: NULL;