APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_F16_HDRS_ALL

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

3171: WHERE check_id = p_check_id;
3172:
3173: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
3174: SELECT a.issue_date
3175: FROM JAI_AP_TDS_F16_HDRS_ALL a, JAI_AP_TDS_F16_DTLS_ALL b
3176: WHERE a.CERTIFICATE_NUM = b.CERTIFICATE_NUM
3177: AND a.org_tan_num = b.org_tan_num
3178: AND a.fin_yr = b.fin_yr
3179: AND b.tds_invoice_id = p_tds_invoice_id;