APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_SYSTEM_OPTIONS

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

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

Line 211: FROM LNS_SYSTEM_OPTIONS

207: g_receivables_trx_id,
208: g_USSGL_TRANSACTION_CODE,
209: g_forgiveness_rec_trx_id,
210: g_set_of_books_id
211: FROM LNS_SYSTEM_OPTIONS
212: WHERE ORG_ID = g_org_id;
213:
214: LogMessage(FND_LOG.LEVEL_STATEMENT, 'System options:');
215: LogMessage(FND_LOG.LEVEL_STATEMENT, 'batch_source_id: ' || g_batch_source_id);

Line 880: FROM LNS_SYSTEM_OPTIONS LSO

876: /* query receivable fund description */
877: CURSOR rec_fund_desc_cur(P_ORG_ID number, P_CC_ID number) IS
878: SELECT
879: FVL.DESCRIPTION
880: FROM LNS_SYSTEM_OPTIONS LSO
881: ,gl_sets_of_books SB
882: ,FND_ID_FLEX_STRUCTURES_VL STR
883: ,FND_ID_FLEX_SEGMENTS_VL SEG
884: ,fnd_flex_value_sets FVS

Line 7566: FROM lns_system_options so

7562: l_loan_start_date date;
7563:
7564: cursor c_ledger is
7565: SELECT so.set_of_books_id
7566: FROM lns_system_options so
7567: ,gl_sets_of_books sb
7568: WHERE sb.set_of_books_id = so.set_of_books_id;
7569:
7570: /*-----------------------------------------------------------------------+