APPS.AP_PREPAY_PKG dependencies on AP_CHECKS_ALL

Line 1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1450:

Line 1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;

1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1450:
1451: -- Other Prepayment Application Related Variables

Line 1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;

1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1450:
1451: -- Other Prepayment Application Related Variables
1452: l_apply_amount NUMBER := p_apply_amount;
1453: l_ppay_apply_amt_in_pay_curr NUMBER;

Line 1567: FROM AP_checks_all AC,

1563: SELECT AC.currency_code,
1564: AC.exchange_rate_type,
1565: AC.exchange_date,
1566: AC.exchange_rate
1567: FROM AP_checks_all AC,
1568: AP_invoice_payments_all AIP
1569: WHERE AC.check_id = AIP.check_id
1570: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1571: AND NOT EXISTS (SELECT 'Invoice payment has been reversed'