APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_F16_HDRS_ALL

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 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 5112: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_F16_DTLS_ALL b

5108: WHERE check_id = p_check_id;
5109:
5110: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
5111: SELECT a.issue_date
5112: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_F16_DTLS_ALL b
5113: WHERE a.CERTIFICATE_NUM = b.CERTIFICATE_NUM
5114: AND a.org_tan_num = b.org_tan_num
5115: AND a.fin_yr = b.fin_yr
5116: AND b.tds_invoice_id = p_tds_invoice_id;