APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on FND_TERRITORIES_VL

Line 1647: x_code fnd_territories_vl.territory_code%TYPE := NULL;

1643: ===========================================================================*/
1644: PROCEDURE validate_country_of_origin(
1645: x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type
1646: ) IS
1647: x_code fnd_territories_vl.territory_code%TYPE := NULL;
1648: x_progress VARCHAR2(3);
1649: x_error_status VARCHAR2(1);
1650: BEGIN
1651: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1655: FROM fnd_territories_vl

1651: x_error_status := rcv_error_pkg.g_ret_sts_error;
1652:
1653: SELECT NVL(MAX(territory_code), 'FF')
1654: INTO x_code
1655: FROM fnd_territories_vl
1656: WHERE territory_code = x_country_of_origin_record.country_of_origin_code;
1657:
1658: IF (x_code = 'FF') THEN
1659: rcv_error_pkg.set_error_message('RCV_ASN_ORIGIN_COUNTRY_INVALID');