APPS.BSC_BSC_ADAPTER dependencies on BSC_SYS_CALENDARS_B

Line 4386: from bsc_sys_calendars_b;

4382: )return boolean is
4383: ----------------
4384: --1001 is DBI ent calendar
4385: cursor c1 is select calendar_id,decode(edw_calendar_type_id,null,0,1,decode(edw_calendar_id,1001,2,1))
4386: from bsc_sys_calendars_b;
4387: ---------------
4388: l_calendar_id BSC_IM_UTILS.number_tabletype;
4389: l_calendar_type BSC_IM_UTILS.number_tabletype;
4390: l_number_calendar_id number;

Line 4418: write_to_log_file_n('select calendar_id from bsc_sys_calendars_b');

4414: null;
4415: end if;*/
4416: --get the list of calendars
4417: if g_debug then
4418: write_to_log_file_n('select calendar_id from bsc_sys_calendars_b');
4419: end if;
4420: l_number_calendar_id:=1;
4421: open c1;
4422: loop

Line 4530: from bsc_sys_calendars_b

4526: )return boolean is
4527: ----------------
4528: --1001 is DBI ent calendar
4529: cursor c1 is select decode(edw_calendar_type_id,null,0,1,decode(edw_calendar_id,1001,2,1))
4530: from bsc_sys_calendars_b
4531: where calendar_id = p_calendar_id;
4532: ---------------
4533: l_calendar_type number;
4534: ---------------

Line 4569: ' from bsc_sys_calendars_b where calendar_id=p_calendar_id');

4565: end if;
4566: --get the calendar type
4567: if g_debug then
4568: write_to_log_file_n('select decode(edw_calendar_type_id,null,0,1,decode(edw_calendar_id,1001,2,1))'||
4569: ' from bsc_sys_calendars_b where calendar_id=p_calendar_id');
4570: end if;
4571: open c1;
4572: fetch c1 into l_calendar_type;
4573: close c1;