APPS.AP_PREPAY_PKG dependencies on AP_CHECKS_ALL

Line 1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1470: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1471: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1472:

Line 1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;

1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1470: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1471: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1472:
1473: -- Other Prepayment Application Related Variables

Line 1471: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;

1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1470: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1471: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1472:
1473: -- Other Prepayment Application Related Variables
1474: l_apply_amount NUMBER := p_apply_amount;
1475: l_ppay_apply_amt_in_pay_curr NUMBER;

Line 1593: FROM AP_checks_all AC,

1589: SELECT AC.currency_code,
1590: AC.exchange_rate_type,
1591: AC.exchange_date,
1592: AC.exchange_rate
1593: FROM AP_checks_all AC,
1594: AP_invoice_payments_all AIP
1595: WHERE AC.check_id = AIP.check_id
1596: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1597: AND AIP.reversal_inv_pmt_id IS NULL -- bug8971713