APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_APP_PREFERENCES_VL

Line 1240: from iex_app_preferences_vl

1236: begin
1237:
1238: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
1239: into l_DefaultStrategyLevel,l_StrategyLevelName
1240: from iex_app_preferences_vl
1241: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = 'Y';
1242:
1243: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1244: write_log(FND_LOG.LEVEL_STATEMENT, ' Strategy level is: ' || l_DefaultStrategyLevel);

Line 1938: from iex_app_preferences_vl

1934: -- End for bug # 5877743 on 28/02/2007 by gnramasa
1935: begin
1936: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
1937: into l_DefaultStrategyLevel,l_StrategyLevelName
1938: from iex_app_preferences_vl
1939: where preference_name = 'COLLECTIONS STRATEGY LEVEL' and enabled_flag = l_Yes;
1940: write_log(FND_LOG.LEVEL_STATEMENT, 'Current Strategy Level ' || l_DefaultStrategyLevel || ' , ' || l_StrategyLevelName);
1941: -- End for bug # 5487449 on 28/08/2006 by gnramasa
1942: EXCEPTION