APPS.JAI_AP_TDS_ETDS_PKG dependencies on AP_INVOICES_ALL

Line 248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
249:
250: -- added, Harshita for Bug 4525089
251:
252: lv_cert_issue_date DATE ;

Line 542: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices

538: fnd_global.user_id,
539: sysdate,
540: fnd_global.user_id,
541: sysdate
542: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices
543: where a.parent_invoice_id = base_invoices.invoice_id
544: and a.invoice_id = tds_invoices.invoice_id
545: and a.invoice_date between p_tds_inv_from_date and p_tds_inv_to_date
546: and a.tax_authority_id = p_tds_vendor_id

Line 566: from JAI_AP_ETDS_T a, ap_invoices_all b

562: Payment Details - tds_check_id, challan_num, challan_date, bank_branch_code
563: --------------------------------- */
564: FOR dtl IN (select a.rowid row_id, a.*,
565: b.vendor_id vendor_id, b.vendor_site_id vendor_site_id, b.invoice_type_lookup_code inv_type
566: from JAI_AP_ETDS_T a, ap_invoices_all b
567: where a.batch_id = p_batch_id and a.base_invoice_id = b.invoice_id)
568: LOOP
569: --added by csahoo for bug#5975168, start
570: ln_con_for_challan := 1;