DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 7364: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;

7360: /* date 08-Aug-2007 by sacsethi for bug 6134628
7361: || Start 6134628
7362: */
7363:
7364: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;
7365: lv_cre_dt DATE;
7366: lv_cre_by NUMBER;
7367: lv_last_upd_dt DATE ;
7368: lv_last_upd_by NUMBER;

Line 7387: FROM JAI_CMN_VENDOR_SITES

7383: flag1 VARCHAR2(10);
7384:
7385: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
7386: SELECT override_flag
7387: FROM JAI_CMN_VENDOR_SITES
7388: WHERE vendor_id = c_vendor_id
7389: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
7390:
7391: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS