APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_INV_PAYMENTS

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

635: AND b.invoice_distribution_id = a.prepay_distribution_id;
636:
637: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
638: SELECT a.issue_date
639: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_INV_PAYMENTS b -- Bug#4517720 ja_in_ap_form16_dtl b
640: WHERE a.certificate_num = b.certificate_num
641: AND a.org_tan_num = b.org_tan_num
642: AND a.fin_yr = b.fin_year
643: AND b.invoice_id = p_tds_invoice_id;

Line 647: FROM JAI_AP_TDS_INV_PAYMENTS jatp

643: AND b.invoice_id = p_tds_invoice_id;
644:
645: CURSOR c_check_date(p_check_id IN NUMBER) IS
646: SELECT nvl(jatp.check_date, jatp.check_date) check_date
647: FROM JAI_AP_TDS_INV_PAYMENTS jatp
648: WHERE
649: check_id = p_check_id;
650: lv_tds_check_date DATE ;
651:

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

794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate
798: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices
799: where a.parent_invoice_id = base_invoices.invoice_id
800: and a.invoice_id = tds_invoices.invoice_id
801: \*Bug 10020606 - All TDS reports must be based on GL Date or date on which TCS Liability is booked*\
802: and base_invoices.gl_date between p_tds_inv_from_date and p_tds_inv_to_date

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

1886: AND b.invoice_distribution_id = a.prepay_distribution_id;
1887:
1888: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
1889: SELECT a.issue_date
1890: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_INV_PAYMENTS b -- Bug#4517720 ja_in_ap_form16_dtl b
1891: WHERE a.certificate_num = b.certificate_num
1892: AND a.org_tan_num = b.org_tan_num
1893: AND a.fin_yr = b.fin_year
1894: AND b.invoice_id = p_tds_invoice_id;

Line 1898: FROM JAI_AP_TDS_INV_PAYMENTS jatp

1894: AND b.invoice_id = p_tds_invoice_id;
1895:
1896: CURSOR c_check_date(p_check_id IN NUMBER) IS
1897: SELECT nvl(jatp.check_date, jatp.check_date) check_date
1898: FROM JAI_AP_TDS_INV_PAYMENTS jatp
1899: WHERE
1900: check_id = p_check_id;
1901: lv_tds_check_date DATE ;
1902: