DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_CASH_ACCOUNTS_ALL

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

220:
221: IF l_account_num is not null
222: THEN
223: --check the line's account is cash related or not.
224: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
225: SELECT count(*) row_count
226: INTO l_account_check
227: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
228: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = TO_CHAR(l_account_num) --using variable l_account_num

Line 227: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc

223: --check the line's account is cash related or not.
224: --Account is cash related one when its number is in table JA_CN_CASH_ACCOUNTS_ALL
225: SELECT count(*) row_count
226: INTO l_account_check
227: FROM JA_CN_CASH_ACCOUNTS_ALL cash_acc
228: WHERE cash_acc.ACCOUNT_SEGMENT_VALUE = TO_CHAR(l_account_num) --using variable l_account_num
229: AND cash_acc.chart_of_accounts_id = l_coa_id; --using variable P_COA_ID
230: --AND cash_acc.SET_OF_BOOKS_ID = l_sob_id; --using variable l_sob_id
231: