APPS.LNS_UTILITY_PUB dependencies on LNS_SYSTEM_OPTIONS

Line 542: FROM lns_system_options so,

538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then
541: SELECT sb.currency_code into l_to_currency
542: FROM lns_system_options so,
543: gl_sets_of_books sb
544: WHERE sb.set_of_books_id = so.set_of_books_id;
545: else
546: l_to_currency := p_to_currency ;

Line 766: from lns_system_options;

762: begin
763:
764: /* 6-3-2005 raverma always return Y
765: select org_id into l_org_id
766: from lns_system_options;
767:
768: return Check_PSA_Enabled_Org(l_org_id);
769: */
770: return 'Y';

Line 886: ,lns_system_options lso

882: cursor c_document_type(p_type varchar2)
883: is
884: select tty.name
885: from ra_cust_trx_types tty
886: ,lns_system_options lso
887: where tty.cust_trx_type_id = decode(p_type, 'PRIN', lso.trx_type_id, 'INT', lso.interest_trx_type_id, 'FEE', lso.fee_trx_type_id);
888: l_name varchar2(20);
889:
890: begin

Line 947: FROM lns_system_options so ;

943:
944: l_fv_enabled_flag := 'N' ;
945: BEGIN
946: SELECT org_id INTO l_org_id
947: FROM lns_system_options so ;
948:
949: l_fv_enabled_flag := IS_FED_FIN_ENABLED(l_org_id) ;
950:
951: EXCEPTION

Line 971: FROM gl_ledgers gl, lns_system_options_all so

967:
968: l_fv_enabled_flag := 'N' ;
969: BEGIN
970: SELECT enable_budgetary_control_flag INTO l_fv_enabled_flag
971: FROM gl_ledgers gl, lns_system_options_all so
972: WHERE so.org_id = p_org_id
973: AND gl.ledger_id = so.set_of_books_id
974: AND fnd_profile.value('FV_ENABLED') = 'Y';
975:

Line 1226: FROM lns_system_options so ;

1222:
1223: l_encum_enabled_flag := 'N' ;
1224: BEGIN
1225: SELECT org_id INTO l_org_id
1226: FROM lns_system_options so ;
1227:
1228: l_encum_enabled_flag := IS_ENCUM_FIN_ENABLED(l_org_id) ;
1229:
1230: EXCEPTION

Line 1292: FROM gl_ledgers gl, lns_system_options_all so

1288:
1289: */
1290:
1291: SELECT enable_budgetary_control_flag INTO l_encum_enabled_flag
1292: FROM gl_ledgers gl, lns_system_options_all so
1293: WHERE so.org_id = p_org_id
1294: AND gl.ledger_id = so.set_of_books_id
1295: AND fnd_profile.value('LNS_ENCUMBRANCE_ENABLE') = 'Y';
1296: