DBA Data[Home] [Help]

APPS.FV_DISB_IN_TRANSIT dependencies on AP_CHECKS_ALL

Line 1058: ap_checks_all ac ,

1054: ac.exchange_date,
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

Line 1177: FROM ap_checks_all ac

1173: SYSDATE,
1174: fnd_global.user_id,
1175: fnd_global.login_id,
1176: org_id
1177: FROM ap_checks_all ac
1178: WHERE org_id = l_org_id
1179: AND void_date IS NOT NULL
1180: AND (ac.checkrun_name IS NOT NULL OR ac.payment_id IS NOT NULL)
1181: AND NOT EXISTS (SELECT 1