APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on AP_TAX_CODES

Line 836: x_name ap_tax_codes.NAME%TYPE := NULL;

832: ===========================================================================*/
833: PROCEDURE validate_tax_code(
834: x_tax_name_record IN OUT NOCOPY rcv_shipment_line_sv.tax_name_record_type
835: ) IS
836: x_name ap_tax_codes.NAME%TYPE := NULL;
837: x_progress VARCHAR2(3);
838: x_error_status VARCHAR2(1);
839: BEGIN
840: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 844: FROM ap_tax_codes

840: x_error_status := rcv_error_pkg.g_ret_sts_error;
841:
842: SELECT NVL(MAX(NAME), 'notfound')
843: INTO x_name
844: FROM ap_tax_codes
845: WHERE NAME = x_tax_name_record.tax_name;
846:
847: IF (x_name = 'notfound') THEN
848: rcv_error_pkg.set_error_message('RCV_ASBN_ITEM_TAX_CODE_DISABLE');

Line 854: FROM ap_tax_codes

850: END IF;
851:
852: SELECT NVL(MAX(NAME), 'notfound')
853: INTO x_name
854: FROM ap_tax_codes
855: WHERE NAME = x_tax_name_record.tax_name
856: AND NVL(inactive_date, SYSDATE + 1) > SYSDATE;
857:
858: IF (x_name = 'notfound') THEN