315: /*
316: v_amount ap_payment_distributions.amount%TYPE;
317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
316: v_amount ap_payment_distributions.amount%TYPE;
317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
317: v_combination_id ap_payment_distributions.dist_code_combination_id%TYPE;
318: */
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
319: v_amount_acct ap_ae_lines_all.accounted_dr%TYPE;
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
320: v_amount ap_ae_lines_all.entered_dr%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
321: v_combination_id ap_ae_lines_all.code_combination_id%TYPE;
322: --LGOEL: Define the following new variables
323: v_cr_amount ap_ae_lines_all.entered_cr%TYPE;
324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
338: v_vendor_id po_vendors.vendor_id%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);
349: seg_prompt VARCHAR2(25);
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;
345: v_curr_conv_date ap_ae_lines.currency_conversion_date%TYPE;
346: v_curr_conv_rate ap_ae_lines.currency_conversion_rate%TYPE;
347:
348: seg_app_name VARCHAR2(40);
349: seg_prompt VARCHAR2(25);
350: seg_value_set_name VARCHAR2(40);
366: ac.check_id
367: FROM fv_treasury_confirmations ftc,
368: ap_checks ac,
369: ap_invoice_payments aip,
370: ap_ae_lines apd,
371: iby_payments_all ipa
372: WHERE ftc.treasury_confirmation_id = x_treasury_confirmation_id
373: AND ftc.payment_instruction_id = ipa.payment_instruction_id
374: AND ipa.payment_id = ac.payment_id