APPS.AMS_DCF_TITLE dependencies on BIM_R_EVEN_DIM_SUM_MV

Line 428: from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;

424: end if;
425: end if;
426: elsif (vSource = 'AMS_BIN_EVENT_EFFECTIVENES') then
427: select year, qtr,month into xYear, xQtr, xMonth
428: from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;
429: xRetString := xYear;
430: if (xQtr <> 'N') then
431: xRetString := xQtr;
432: end if;

Line 667: from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;

663: end if;
664: end if;
665: elsif (vSource = 'AMS_BIN_EVENT_EFFECTIVENES') then
666: select year, qtr,month into xYear, xQtr, xMonth
667: from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;
668: xRetString := xYear;
669: if (xQtr <> 'N') then
670: xRetString := xQtr;
671: end if;