APPS.PO_VAL_SHIPMENTS2 dependencies on ZX_ID_TCC_MAPPING

Line 1990: -- then tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping

1986:
1987: -------------------------------------------------------------------------
1988: -- tax_name must be valid if it is not null;
1989: -- If tax_name and tax_code_id are both not null,
1990: -- then tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1991: -------------------------------------------------------------------------
1992: PROCEDURE tax_name(
1993: p_id_tbl IN po_tbl_number,
1994: p_tax_name_tbl IN po_tbl_varchar30,

Line 2060: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping

2056: IF (SQL%ROWCOUNT > 0) THEN
2057: x_result_type := po_validations.c_result_type_failure;
2058: END IF;
2059:
2060: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
2061: -- if both are not null
2062: FORALL i IN 1 .. p_id_tbl.COUNT
2063: INSERT INTO po_validation_results_gt
2064: (result_set_id,

Line 2088: FROM ZX_ID_TCC_MAPPING

2084: FROM DUAL
2085: WHERE p_tax_code_id_tbl(i) IS NOT NULL
2086: AND p_tax_name_tbl(i) IS NOT NULL
2087: AND NOT EXISTS(SELECT 'Y'
2088: FROM ZX_ID_TCC_MAPPING
2089: WHERE tax_rate_code_id = p_tax_code_id_tbl(i)
2090: AND tax_classification_code = p_tax_name_tbl(i)
2091: AND NVL(p_need_by_date_tbl(i),SYSDATE) BETWEEN
2092: NVL(effective_from, SYSDATE) AND