APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRATEGY_TEMPLATES_VL

Line 218: SELECT decode(COUNT(*), 0, 'N', 'Y') into pre_delinquency_flag FROM IEX_STRATEGY_TEMPLATES_VL

214: -- Standard Start of API savepoint
215: SAVEPOINT START_STRY_CONT;
216:
217: begin
218: SELECT decode(COUNT(*), 0, 'N', 'Y') into pre_delinquency_flag FROM IEX_STRATEGY_TEMPLATES_VL
219: WHERE CATEGORY_TYPE = l_DelStatusPreDel;
220: EXCEPTION
221: WHEN OTHERS THEN
222: fnd_file.put_line(FND_FILE.LOG, 'Pre Delinquency flag raised exception; sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

Line 582: from iex_strategy_templates_vl where strategy_temp_id = vStrategyTemplateId;

578: if (vStrategyStatus = 'OPEN' or vStrategyStatus = 'PENDING') then
579: begin
580: select strategy_rank, decode(score_tolerance, null, 0, score_tolerance), change_strategy_yn
581: into vStrategyRank, vScoreTolerance, vChangeStrategy
582: from iex_strategy_templates_vl where strategy_temp_id = vStrategyTemplateId;
583: exception
584: when others then
585: vStrategyRank := '0';
586: vScoreTolerance := 0;

Line 1904: from iex_strategy_templates_vl

1900: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Default Template ID ' || l_DefaultTempID || ' Profile Name IEX: Strategy Default Template (IEX_STRATEGY_DEFAULT_TEMPLATE)');
1901: begin
1902: select STRATEGY_NAME ,ENABLED_FLAG
1903: into l_DefaultTempName, l_EnabledFlag
1904: from iex_strategy_templates_vl
1905: where STRATEGY_TEMP_ID=l_DefaultTempID;
1906:
1907: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Default Template Name :' || l_DefaultTempName || ' , Enabled Flag :' || l_EnabledFlag );
1908: EXCEPTION