DBA Data[Home] [Help]

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 970: FROM gl_ledgers gl, lns_system_options_all so

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