APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 948: FROM jai_ap_tds_vendor_hdrs

944: -- (actual_tax_id is NOT NULL) --added by Xiao for Bug#7154864
945: /*FP of QA Bug 12431997 - Included in 11896260 - Tax to be deducted irrespective of Threshold if PAN is not available*/
946: OR
947: EXISTS (SELECT 1
948: FROM jai_ap_tds_vendor_hdrs
949: WHERE (pan_no IN ('PANAPPLIED','PANNOTAVBL','PANINVALID')
950: OR (pan_no IS NOT NULL AND confirm_pan_flag IS NULL))
951: AND vendor_site_id = 0
952: AND vendor_id = (SELECT vendor_id

Line 966: JAI_AP_TDS_VENDOR_HDRS c,

962: d.org_tan_num tan_no,
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

Line 1124: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;

1120: ln_threshold_trx_id number;
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;

Line 1126: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/

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