DBA Data[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_ORG_TAN_V

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

2581: c.confirm_pan_flag confirm_pan_flag /*Fixing QA Bug 12431997 - Included in 11896260*/
2582: from po_vendors a,
2583: po_vendor_sites_all b,
2584: JAI_AP_TDS_VENDOR_HDRS c,
2585: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
2586: where a.vendor_id = b.vendor_id
2587: and b.vendor_id = c.vendor_id
2588: and b.vendor_site_id = c.vendor_site_id
2589: and b.org_id = d.organization_id

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

2770: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
2771: lv_tds_cm_num ap_invoices_all.invoice_num%type;
2772:
2773: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
2774: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
2775: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/
2776: ln_exchange_rate number;
2777: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
2778: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;