DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on JA_CN_CASH_ACCOUNTS_ALL

Line 209: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL

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

Line 212: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc

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: