DBA Data[Home] [Help]

APPS.AMS_DCF_TITLE dependencies on BIM_R_CAMP_DIM_SUM_MV

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

434: xRetString := xMonth;
435: end if;
436: elsif (vSource = 'AMS_BIN_CAMP_EFFECTIVENESS') then
437: select year, qtr,month into xYear, xQtr, xMonth
438: from BIM_R_CAMP_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;
439: xRetString := xYear;
440: if (xQtr <> 'N') then
441: xRetString := xQtr;
442: end if;

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

673: xRetString := xMonth;
674: end if;
675: elsif (vSource = 'AMS_BIN_CAMP_EFFECTIVENESS') then
676: select year, qtr,month into xYear, xQtr, xMonth
677: from BIM_R_CAMP_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;
678: xRetString := xYear;
679: if (xQtr <> 'N') then
680: xRetString := xQtr;
681: end if;