APPS.JAI_PO_TAX_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 5948: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;

5944: /* date 08-Aug-2007 by sacsethi for bug 6134628
5945: || Start 6134628
5946: */
5947:
5948: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;
5949: lv_cre_dt DATE;
5950: lv_cre_by NUMBER;
5951: lv_last_upd_dt DATE ;
5952: lv_last_upd_by NUMBER;

Line 5971: FROM JAI_CMN_VENDOR_SITES

5967: flag1 VARCHAR2(10);
5968:
5969: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
5970: SELECT override_flag
5971: FROM JAI_CMN_VENDOR_SITES
5972: WHERE vendor_id = c_vendor_id
5973: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
5974:
5975: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS