DBA Data[Home] [Help]

APPS.FV_AP_CASH_POS_DTL_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 193: FROM ap_inv_selection_criteria_all

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

Line 207: ap_inv_selection_criteria_all apis

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;