576: IF fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR'
577: THEN
578: SELECT count(1)
579: INTO l_count
580: FROM ce_bank_accounts ba, ce_bank_acct_uses_all bau
581: WHERE ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id
582: AND bau.bank_account_id = ba.bank_account_id
583: AND ba.xtr_use_allowed_flag = 'Y'
584: AND bau.authorized_flag = 'Y';