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 967: jai_ap_tds_org_tan_v d --rchandan for bug#4323338

963: c.confirm_pan_flag confirm_pan_flag /*Fixing QA Bug 12431997 - Included in 11896260*/
964: from po_vendors a,
965: po_vendor_sites_all b,
966: JAI_AP_TDS_VENDOR_HDRS c,
967: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
968: where a.vendor_id = b.vendor_id
969: and b.vendor_id = c.vendor_id
970: and b.vendor_site_id = c.vendor_site_id
971: and b.org_id = d.organization_id

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

1121: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
1122: lv_tds_cm_num ap_invoices_all.invoice_num%type;
1123:
1124: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
1125: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
1126: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/
1127: ln_exchange_rate number;
1128: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
1129: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;