APPS.AMS_DCF_LEADS_TITLE dependencies on BIM_R_PERIODS

Line 22: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;

18: xPeriod varchar2(80);
19:
20: BEGIN
21: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
22: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;
23: return (xPeriod);
24: EXCEPTION
25: WHEN OTHERS THEN
26: null;

Line 55: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;

51: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
52: -- vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
53: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
54: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
55: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;
56:
57: return (vRepName||' '||vFor||' '|| xPeriod);
58: EXCEPTION
59: WHEN OTHERS THEN

Line 338: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

334: and rownum < 2;
335: if (xDisplayType <> 'Z') then
336: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
337: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
338: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
339: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
340: else
341: xRetString := xYear;
342: if (xQtr <> 'N') then