DBA Data[Home] [Help]

APPS.AP_PMT_VALIDATIONS_PKG dependencies on CE_BANK_ACCT_USES_ALL

Line 42: ce_bank_acct_uses_all ce

38: ce.bank_acct_use_id
39: FROM iby_fd_payments_v pmt,
40: iby_pay_instructions_all ins,
41: iby_payment_profiles ipp,
42: ce_bank_acct_uses_all ce
43: WHERE pmt.completed_pmts_group_id = p_completed_pmts_group_id
44: AND ipp.payment_profile_id = ins.payment_profile_id
45: AND ins.payment_instruction_id = pmt.payment_instruction_id
46: AND ce.org_id = pmt.org_id

Line 207: ce_bank_acct_uses_all ce,

203: SELECT COUNT(*) ap_check_count
204: INTO l_ap_pmt_count
205: FROM iby_fd_payments_v iby,
206: po_vendors pv,
207: ce_bank_acct_uses_all ce,
208: ce_gl_accounts_ccid cegl,
209: ce_bank_accounts ceb,
210: ap_supplier_sites_all aps
211: WHERE iby.inv_payee_party_id = pv.party_id(+)