DBA Data[Home] [Help]

APPS.WSH_CREATE_CARRIERS_PKG dependencies on HZ_PARTY_SITES

Line 1492: FROM hz_party_sites

1488: WHERE carrier_id = p_carrier_id;
1489:
1490: CURSOR C_get_carrier_sites(p_carrier_id NUMBER) IS
1491: SELECT party_site_id
1492: FROM hz_party_sites
1493: WHERE party_id=p_carrier_id;
1494:
1495:
1496: CURSOR Get_Site_Object_Number(p_party_site_id NUMBER) IS

Line 1498: from hz_party_sites

1494:
1495:
1496: CURSOR Get_Site_Object_Number(p_party_site_id NUMBER) IS
1497: select object_version_number
1498: from hz_party_sites
1499: where party_site_id = p_party_site_id;
1500:
1501:
1502: CURSOR C_lookup_row(p_ship_method_code VARCHAR2) IS