DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_CASH_ACCOUNTS_ALL

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

211:
212: IF l_account_num is not null
213: THEN
214: --check the line's account is cash related or not.
215: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
216: SELECT count(*) row_count
217: INTO l_account_check
218: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
219: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = TO_CHAR(l_account_num) --using variable l_account_num

Line 218: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc

214: --check the line's account is cash related or not.
215: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
216: SELECT count(*) row_count
217: INTO l_account_check
218: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
219: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = TO_CHAR(l_account_num) --using variable l_account_num
220: AND cash_acc.chart_of_accounts_id = l_coa_id; --using variable P_COA_ID
221: --AND cash_acc.SET_OF_BOOKS_ID = l_sob_id; --using variable l_sob_id
222: