APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_INV_PAYMENTS

Line 317: JAI_AP_TDS_INV_PAYMENTS jatp

313: apc.attribute3 challan_num,
314: apc.attribute1 challan_date, -- pay.invoice_payment_id
315: apc.check_number
316: FROM ap_checks_all apc,
317: JAI_AP_TDS_INV_PAYMENTS jatp
318: WHERE
319: apc.check_id = jatp.check_id AND
320: jatp.check_id = cp_check_id;*/
321:

Line 373: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_INV_PAYMENTS b -- Bug#4517720 ja_in_ap_form16_dtl b

369: AND CEBA.BANK_ACCOUNT_ID = p_bank_account_id;*/
370:
371: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
372: SELECT a.issue_date
373: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_INV_PAYMENTS b -- Bug#4517720 ja_in_ap_form16_dtl b
374: WHERE a.certificate_num = b.certificate_num
375: AND a.org_tan_num = b.org_tan_num
376: AND a.fin_yr = b.fin_year
377: AND b.invoice_id = p_tds_invoice_id;

Line 382: FROM JAI_AP_TDS_INV_PAYMENTS jatp

378:
379: CURSOR c_check_date(p_check_id IN NUMBER) IS
380: SELECT nvl(jatp.check_date, jatp.check_date) check_date
381: /* decode (attribute1, NULL,check_date,to_date(attribute1)) */
382: FROM JAI_AP_TDS_INV_PAYMENTS jatp
383: WHERE
384: check_id = p_check_id;
385: lv_tds_check_date DATE ;
386:

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