[Home] [Help]
337: v_check_id ap_checks.check_id%TYPE;
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;
365: aip.invoice_id,
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
373: AND ftc.payment_instruction_id = ipa.payment_instruction_id
374: AND ipa.payment_id = ac.payment_id
375: AND ac.check_id = aip.check_id
376: AND (( aip.invoice_payment_id = apd.source_id
377: AND apd.source_table ='AP_INVOICE_PAYMENTS')
378: OR
379: ( aip.check_id = apd.source_id
380: AND apd.source_table = 'AP_CHECKS'))
381: AND apd.ae_line_type_code IN ('CASH','CASH CLEARING','FUTURE PAYMENT')
1055: ac.void_date
1056: FROM fv_treasury_confirmations_all ftc,
1057: fv_voided_checks fvt,
1058: ap_checks_all ac ,
1059: ap_invoice_payments_all apip,
1060: iby_payments_all ipa
1061: WHERE ac.check_id = fvt.check_id
1062: AND ac.payment_id = ipa.payment_id
1063: AND ipa.payment_instruction_id = ftc.payment_instruction_id
1235: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name, 'Fetched check id is = '||voided_checks_list_rec.check_id);
1236: END IF;
1237:
1238: select accounting_date into v_accounting_date
1239: from ap_invoice_payments_all
1240: where check_id =voided_checks_list_rec.check_id
1241: and REVERSAL_INV_PMT_ID is not null
1242: and REVERSAL_FLAG = 'Y'
1243: and rownum =1;