APPS.MSC_HUB_CALENDAR dependencies on MSC_PLANS

Line 86: from msc_plans where plan_id=p_plan_id;

82: l_plan_type number;
83: begin
84:
85: select plan_type into l_plan_type
86: from msc_plans where plan_id=p_plan_id;
87:
88: if (l_plan_type = 6) then -- SNO
89: return trunc(p_bkt_end_date);
90: end if;

Line 101: from msc_trading_partners mtp, msc_plans mp

97:
98: l_calendar_Code := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');
99: if (l_calendar_code is null) then
100: select mtp.calendar_code into l_calendar_code
101: from msc_trading_partners mtp, msc_plans mp
102: where mtp.sr_tp_id = mp.organization_id
103: and mtp.sr_instance_id = mp.sr_instance_id
104: and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;
105:

Line 269: from msc_plans where plan_id=p_plan_id;

265: and p_date between bkt_start_date and bkt_end_date;
266:
267:
268: select sr_instance_id into l_sr_instance_id
269: from msc_plans where plan_id=p_plan_id;
270:
271:
272: return msc_hub_calendar.last_work_date(p_plan_id,l_sr_instance_id,
273: l_bkt_type,l_bkt_start_date,

Line 279: from msc_plans where plan_id = p_plan_id;

275: exception
276:
277: when no_data_found then -- if the date is not in any bucket, return the plan start date
278: select curr_start_date into x_date
279: from msc_plans where plan_id = p_plan_id;
280:
281: return x_date;
282: end last_work_date;
283:

Line 328: from msc_trading_partners mtp, msc_plans mp

324:
325: l_calendar_Code := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');
326: if (l_calendar_code is null) then
327: select mtp.calendar_code into l_calendar_code
328: from msc_trading_partners mtp, msc_plans mp
329: where mtp.sr_tp_id = mp.organization_id
330: and mtp.sr_instance_id = mp.sr_instance_id
331: and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;
332: