APPS.JAI_AP_TDS_ETDS_PKG dependencies on AP_CHECKS_ALL

Line 243: ln_check_number ap_checks_all.check_number%TYPE;

239: v_prepay_invoice_id NUMBER;
240: v_prepayment_amount_applied NUMBER;
241:
242: /* Bug 4353842. Added by Lakshmi Gopalsami */
243: ln_check_number ap_checks_all.check_number%TYPE;
244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

Line 287: FROM ap_invoice_payments_all PAY, ap_checks_all APC

283: -- p_invoice_id contains tds_invoice_id incase if tds amount is directly paid to TDS Authorities using a c
284: -- p_invoice_id contains PREPAYMENT invoice_id to TDS Auth., if TDS invoice is applied to PREPAYMENT invo
285: /*CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
286: SELECT pay.check_id, apc.bank_account_id, apc.attribute3 challan_num, apc.attribute1 challan_date -- p
287: FROM ap_invoice_payments_all PAY, ap_checks_all APC
288: WHERE PAY.invoice_id = p_invoice_id
289: AND PAY.check_id = APC.check_id
290: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);--rchandan for bug#4428980
291:

Line 294: FROM ap_invoice_payments_all PAY, ap_checks_all APC

290: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);--rchandan for bug#4428980
291:
292: CURSOR c_base_payment_check_id(p_invoice_id IN NUMBER) IS
293: SELECT pay.check_id, apc.bank_account_id, check_date
294: FROM ap_invoice_payments_all PAY, ap_checks_all APC
295: WHERE PAY.invoice_id = p_invoice_id
296: AND PAY.check_id = APC.check_id
297: AND APC.status_lookup_code NOT IN (lv_voided, lv_stop_init);--rchandan for bug#4428980*/
298:

Line 308: FROM ap_checks_all APC

304: apc.attribute3 challan_num,
305: apc.attribute1 challan_date, */ -- pay.invoice_payment_id
306: /* Bug 4353842. Added by Lakshmi Gopalsami */
307: /* apc.check_number
308: FROM ap_checks_all APC
309: WHERE check_id = cpn_check_id;*/
310:
311: /*CURSOR c_check_dtls(cp_check_id IN NUMBER) IS
312: SELECT apc.bank_account_id,

Line 316: FROM ap_checks_all apc,

312: SELECT apc.bank_account_id,
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;*/

Line 3170: FROM ap_checks_all

3166: AND vendor_site_id = p_vendor_site_id;
3167:
3168: CURSOR c_check_dtls(p_check_id IN NUMBER) IS
3169: SELECT check_date
3170: FROM ap_checks_all
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