eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 285: FROM JAI_CMN_VENDOR_SITES A

281:
282: -- to get state
283: CURSOR cur_state(pn_vendor_site_id IN NUMBER DEFAULT 0) IS
284: SELECT STATE_CODE
285: FROM JAI_CMN_VENDOR_SITES A
286: WHERE a.vendor_id = pn_vendor_id
287: AND a.vendor_site_id = pn_vendor_site_id;
288:
289: v_vendor_state VARCHAR2(120);

Line 362: FROM JAI_CMN_VENDOR_SITES A

358:
359: -- to get state
360: CURSOR cur_state(pn_vendor_site_id IN NUMBER DEFAULT 0) IS
361: SELECT STATE_CODE
362: FROM JAI_CMN_VENDOR_SITES A
363: WHERE a.vendor_id = pn_vendor_id
364: AND a.vendor_site_id = pn_vendor_site_id;
365:
366: v_vendor_state VARCHAR2(120);

Line 589: FROM JAI_CMN_VENDOR_SITES A

585:
586: -- to get tax_category_list
587: CURSOR tax_catg_list_cur(pn_vendor_id IN NUMBER, pn_vendor_site_id IN NUMBER DEFAULT 0) IS
588: SELECT tax_category_list
589: FROM JAI_CMN_VENDOR_SITES A
590: WHERE a.vendor_id = pn_vendor_id
591: AND a.vendor_site_id = pn_vendor_site_id;
592:
593: -- to get tax_category_id