APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_CHECKS_ALL

Line 444: l_payment_type_flag AP_CHECKS_ALL.payment_type_flag%TYPE;

440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
442: l_prepay_hist_rec r_prepay_hist_info;
443: l_prepay_dist_rec r_prepay_dist_info;
444: l_payment_type_flag AP_CHECKS_ALL.payment_type_flag%TYPE;
445: l_pay_trx_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
446:
447: -- bug9492002
448: -- commenting below for bug10183934

Line 638: FROM ap_checks_all ac,

634: l_payment_type_flag := 'Q';
635:
636: SELECT DISTINCT ac.payment_type_flag
637: INTO l_payment_type_flag
638: FROM ap_checks_all ac,
639: ap_invoice_payments_all aip
640: WHERE ac.check_id = aip.check_id
641: AND aip.invoice_id = l_prepay_hist_rec.prepay_invoice_id
642: AND rownum < 2;