APPS.PO_VAL_SHIPMENTS2 dependencies on ZX_ID_TCC_MAPPING

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

1563:
1564: -------------------------------------------------------------------------
1565: -- tax_name must be valid if it is not null;
1566: -- If tax_name and tax_code_id are both not null,
1567: -- then tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1568: -------------------------------------------------------------------------
1569: PROCEDURE tax_name(
1570: p_id_tbl IN po_tbl_number,
1571: p_tax_name_tbl IN po_tbl_varchar30,

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

1633: IF (SQL%ROWCOUNT > 0) THEN
1634: x_result_type := po_validations.c_result_type_failure;
1635: END IF;
1636:
1637: -- tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1638: -- if both are not null
1639: FORALL i IN 1 .. p_id_tbl.COUNT
1640: INSERT INTO po_validation_results_gt
1641: (result_set_id,

Line 1665: FROM ZX_ID_TCC_MAPPING

1661: FROM DUAL
1662: WHERE p_tax_code_id_tbl(i) IS NOT NULL
1663: AND p_tax_name_tbl(i) IS NOT NULL
1664: AND NOT EXISTS(SELECT 'Y'
1665: FROM ZX_ID_TCC_MAPPING
1666: WHERE tax_rate_code_id = p_tax_code_id_tbl(i)
1667: AND tax_classification_code = p_tax_name_tbl(i)
1668: AND NVL(p_need_by_date_tbl(i),SYSDATE) BETWEEN
1669: NVL(effective_from, SYSDATE) AND