APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_CMN_VENDOR_SITES

Line 1987: jai_cmn_vendor_sites

1983: CURSOR get_tax_service_cur IS
1984: SELECT
1985: tax_category_id, service_type_code
1986: FROM
1987: jai_cmn_vendor_sites
1988: WHERE NVL (vendor_site_id, 0) = pn_vendor_site_id
1989: AND vendor_id = pn_vendor_id;
1990:
1991: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 2848: select tax_category_id from jai_cmn_vendor_sites where vendor_id =p_supplier_id

2844:
2845:
2846: -- Get the tax category_id of supplier id
2847: cursor get_setup_tax_category_id ( p_supplier_id number , p_supplier_site_id number) is
2848: select tax_category_id from jai_cmn_vendor_sites where vendor_id =p_supplier_id
2849: and vendor_site_id = p_supplier_site_id;
2850:
2851:
2852: