APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_VNDR_TYPE_V

Line 1611: from JAI_AP_TDS_VNDR_TYPE_V

1607: AND cp_accounting_date between nvl(from_date, cp_accounting_date) and nvl(to_date, cp_accounting_date);
1608:
1609: cursor c_po_vendors(p_vendor_id number) is
1610: select tds_vendor_type_lookup_code
1611: from JAI_AP_TDS_VNDR_TYPE_V
1612: where vendor_id = p_vendor_id;
1613: lv_vendor_type_lookup_code JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
1614: lv_valid_flg VARCHAR2(1);
1615: l_api_name CONSTANT VARCHAR2(50) := 'get_threshold_hdr()';

Line 2459: from JAI_AP_TDS_VNDR_TYPE_V

2455: --having sum(tax_amount) <> 0; --Commented by Bgowrava for Bug#8254510
2456:
2457: cursor c_po_vendors(p_vendor_id number) is
2458: select tds_vendor_type_lookup_code
2459: from JAI_AP_TDS_VNDR_TYPE_V
2460: where vendor_id = p_vendor_id;
2461:
2462: cursor c_get_threshold
2463: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980