APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_ORG_TAN_V

Line 36: and a view jai_ap_tds_org_tan_v is created to retrieve the PAN NO.

32: tables the jai_ap_tds_thhold_trxs table is also populated.
33:
34: 3. 11/05/2005 rchandan for bug#4323338. Version 116.2
35: India Org Info DFF is eliminated as a part of JA migration. A table by name JAI_AP_TDS_ORG_TANS is dropped
36: and a view jai_ap_tds_org_tan_v is created to retrieve the PAN NO.
37:
38: 4. 24/05/2005 Ramananda for bug#4388958 File Version: 116.1
39: Changed AP Lookup code from 'TDS' to 'INDIA TDS'
40:

Line 490: jai_ap_tds_org_tan_v d --rchandan for bug#4323338

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
494: and b.org_id = d.organization_id

Line 558: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338

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;
562: