APPS.JA_CN_SYSOPS_BANK_PKG dependencies on GL_ACCESS_SET_LEDGERS

Line 92: FROM GL_ACCESS_SET_LEDGERS gas

88:
89:
90: CURSOR CUR_LEDGER IS
91: SELECT ledger_id
92: FROM GL_ACCESS_SET_LEDGERS gas
93: where gas.access_set_id = p_access_set_id;
94:
95: lv_procedure_name VARCHAR2(40) := 'Get_BSV_LIST';
96: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 185: x_where := x_where ||' and ledger_id in (select ledger_id from gl_access_set_ledgers where access_set_id='||p_access_set_id||')';

181: END LOOP;
182:
183: <>
184: x_where := 'FLEX_SEGMENT_VALUE in ('|| substr(x_bsv_list,2,length(x_bsv_list)) ||')';
185: x_where := x_where ||' and ledger_id in (select ledger_id from gl_access_set_ledgers where access_set_id='||p_access_set_id||')';
186: --logging for debug
187: IF (ln_proc_level >= ln_dbg_level) THEN
188: FND_LOG.STRING(ln_proc_level,
189: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',