DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on JA_CN_CASH_ACCOUNTS_ALL

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

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

Line 210: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc

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