APPS.FV_DISB_IN_TRANSIT dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1059: ap_invoice_payments_all apip,

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

Line 1239: from ap_invoice_payments_all

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;