DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_CMN_VENDOR_SITES

Line 2312: jai_cmn_vendor_sites

2308: CURSOR get_tax_service_cur IS
2309: SELECT
2310: tax_category_id, service_type_code
2311: FROM
2312: jai_cmn_vendor_sites
2313: WHERE NVL (vendor_site_id, 0) = pn_vendor_site_id
2314: AND vendor_id = pn_vendor_id;
2315:
2316: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 3343: select tax_category_id from jai_cmn_vendor_sites where vendor_id =p_supplier_id

3339:
3340:
3341: -- Get the tax category_id of supplier id
3342: cursor get_setup_tax_category_id ( p_supplier_id number , p_supplier_site_id number) is
3343: select tax_category_id from jai_cmn_vendor_sites where vendor_id =p_supplier_id
3344: and vendor_site_id = p_supplier_site_id;
3345:
3346:
3347: