DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on JAI_IM_TAX_MAPPING

Line 1729: FROM JAI_IM_TAX_MAPPING

1725: cv_external_tax_code IN JAI_INTERFACE_TAX_LINES_ALL.EXTERNAL_TAX_CODE%TYPE,
1726: cv_taxable_event IN JAI_INTERFACE_LINES_ALL.TAXABLE_EVENT%TYPE
1727: )IS
1728: SELECT TAX_ID
1729: FROM JAI_IM_TAX_MAPPING
1730: WHERE ORG_ID = cn_org_id
1731: AND EXTERNAL_TAX_CODE = cv_external_tax_code
1732: AND TAXABLE_EVENT = cv_taxable_event;
1733:

Line 1744: FROM JAI_IM_TAX_MAPPING

1740: AND ORG_ID = pr_interface_lines.ORG_ID;
1741:
1742: CURSOR get_use_flag IS
1743: SELECT distinct(use_ebs_tax)
1744: FROM JAI_IM_TAX_MAPPING
1745: WHERE org_id = pr_interface_lines.ORG_ID
1746: AND taxable_event = pr_interface_lines.taxable_event;
1747:
1748: CURSOR get_tax_id_rec(

Line 4686: FROM JAI_IM_TAX_MAPPING

4682: WHERE tax_category_id = cn_category_id;
4683:
4684: CURSOR get_not_ebs_tax_flag IS
4685: SELECT count(1)
4686: FROM JAI_IM_TAX_MAPPING
4687: WHERE org_id = pr_interface_lines.org_id
4688: AND taxable_event = pr_interface_lines.taxable_event
4689: AND use_ebs_tax = 'N';
4690: