205:
206: IF l_account_num is not null
207: THEN
208: --check the line's account is cash related or not.
209: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
210: SELECT count(*) row_count
211: INTO l_account_check
212: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
213: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = l_account_num --using variable l_account_num
208: --check the line's account is cash related or not.
209: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
210: SELECT count(*) row_count
211: INTO l_account_check
212: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
213: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = l_account_num --using variable l_account_num
214: AND cash_acc.chart_of_accounts_id = l_coa_id --using variable l_coa_id
215: ;
216: