APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_SYSTEM_OPTIONS

Line 162: select count(1) into g_sys_opt_num from LNS_SYSTEM_OPTIONS where ORG_ID = g_org_id;

158: l_org_status := MO_GLOBAL.check_valid_org(g_org_id);
159: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.check_valid_org(' || g_org_id || '): ' || l_org_status);
160:
161: /* checking for number of system options record for giving org_id */
162: select count(1) into g_sys_opt_num from LNS_SYSTEM_OPTIONS where ORG_ID = g_org_id;
163:
164: if g_sys_opt_num = 0 then
165:
166: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No system options found for the org ' || g_org_id);

Line 205: FROM LNS_SYSTEM_OPTIONS

201: g_fee_trx_type_id,
202: g_receivables_trx_id,
203: g_USSGL_TRANSACTION_CODE,
204: g_forgiveness_rec_trx_id
205: FROM LNS_SYSTEM_OPTIONS
206: WHERE ORG_ID = g_org_id;
207:
208: LogMessage(FND_LOG.LEVEL_STATEMENT, 'System options:');
209: LogMessage(FND_LOG.LEVEL_STATEMENT, 'batch_source_id: ' || g_batch_source_id);

Line 873: FROM LNS_SYSTEM_OPTIONS LSO

869: /* query receivable fund description */
870: CURSOR rec_fund_desc_cur(P_ORG_ID number, P_CC_ID number) IS
871: SELECT
872: FVL.DESCRIPTION
873: FROM LNS_SYSTEM_OPTIONS LSO
874: ,gl_sets_of_books SB
875: ,FND_ID_FLEX_STRUCTURES_VL STR
876: ,FND_ID_FLEX_SEGMENTS_VL SEG
877: ,fnd_flex_value_sets FVS

Line 6929: FROM lns_system_options so

6925: l_installment_number number;
6926:
6927: cursor c_ledger is
6928: SELECT so.set_of_books_id
6929: FROM lns_system_options so
6930: ,gl_sets_of_books sb
6931: WHERE sb.set_of_books_id = so.set_of_books_id;
6932:
6933: /*-----------------------------------------------------------------------+