APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_F16_DTLS_ALL
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;