APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 489: JAI_AP_TDS_VENDOR_HDRS c,

485: select c.pan_no pan_no,
486: d.org_tan_num tan_no
487: from po_vendors a,
488: po_vendor_sites_all b,
489: JAI_AP_TDS_VENDOR_HDRS c,
490: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
491: where a.vendor_id = b.vendor_id
492: and b.vendor_id = c.vendor_id
493: and b.vendor_site_id = c.vendor_site_id

Line 557: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;

553: ln_threshold_trx_id number;
554: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
555: lv_tds_cm_num ap_invoices_all.invoice_num%type;
556:
557: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
558: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
559: ln_exchange_rate number;
560: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
561: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;