[Home] [Help]
25: functionality onto AP invoice.
26:
27: 2. 2/05/2005 rchandan for bug#4323338. Version 116.0
28: India Org Info DFF is eliminated as a part of JA migration. A table by name ja_in_ap_tds_org_tan is dropped
29: and a view jai_ap_tds_org_tan_v is created to capture the PAN No,TAN NO and WARD NO. The code changes are done
30: to refer to the new view instead of the dropped table.
31:
32:
33: 3. 08-Jun-2005 Version 116.1 jai_ap_tds_dflt -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
1447: d.org_tan_num tan_no
1448: from po_vendors a,
1449: po_vendor_sites_all b,
1450: jai_ap_tds_vendor_hdrs c,
1451: jai_ap_tds_org_tan_v d --- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1452: where a.vendor_id = b.vendor_id
1453: and b.vendor_id = c.vendor_id
1454: and b.vendor_site_id = c.vendor_site_id
1455: and b.org_id = d.organization_id
1478: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1479: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1480:
1481: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1482: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type;--- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1483:
1484:
1485: ln_total_invoice_amount number;
1486: ln_amount_for_redefault number;