189: AND flex_value = p_acct ;
190: --changed checkrun_name to checkrun_id
191: CURSOR check_date_cur(p_checkrun_id NUMBER) IS
192: SELECT check_date,checkrun_name
193: FROM ap_inv_selection_criteria_all
194: WHERE checkrun_id = p_checkrun_id;
195:
196: --changed checkrun_name to checkrun_id
197: CURSOR invoice_count_cur(p_checkrun_id NUMBER) IS
203: CURSOR bank_acct_cur(p_checkrun_id NUMBER) IS
204: SELECT cba.pooled_flag, cba.bank_account_name
205: FROM ce_bank_accounts cba ,
206: Ce_bank_acct_uses_all cbaua,
207: ap_inv_selection_criteria_all apis
208: WHERE apis.checkrun_id = p_checkrun_id
209: ---;)-- AND apis.bank_account_id = cbaua.bank_account_id
210: AND apis.ce_bank_acount_use_id = cbaua.bank_account_id
211: AND cbaua.bank_account_id = cba.bank_account_id;