APPS.MSC_SATP_FUNC dependencies on MTL_PARAMETERS

Line 240: mtl_parameters org

236: -- bug 2974334. Change the SQL into static.
237: SELECT cal.prior_date
238: INTO l_return_date
239: FROM bom_calendar_dates cal,
240: mtl_parameters org
241: WHERE cal.calendar_code = org.calendar_code
242: AND cal.exception_set_id = org.calendar_exception_set_id
243: AND cal.calendar_date = TRUNC(p_date)
244: AND org.organization_id = p_organization_id;

Line 253: mtl_parameters org

249: BEGIN
250: SELECT min(calendar_date), max(calendar_date)
251: INTO l_first_work_day, l_last_work_day
252: FROM BOM_CALENDAR_DATES cal,
253: mtl_parameters org
254: WHERE cal.calendar_code = org.calendar_code
255: AND cal.exception_set_id = org.calendar_exception_set_id
256: AND org.organization_id = p_organization_id
257: AND cal.seq_num is not null;

Line 293: mtl_parameters org

289: -- bug 2974334. Change the SQL into static.
290: SELECT cal.next_date
291: INTO l_return_date
292: FROM bom_calendar_dates cal,
293: mtl_parameters org
294: WHERE cal.calendar_code = org.calendar_code
295: AND cal.exception_set_id = org.calendar_exception_set_id
296: AND cal.calendar_date = TRUNC(p_date)
297: AND org.organization_id = p_organization_id;

Line 307: mtl_parameters org

303: BEGIN
304: SELECT min(calendar_date), max(calendar_date)
305: INTO l_first_work_day, l_last_work_day
306: FROM BOM_CALENDAR_DATES cal,
307: mtl_parameters org
308: WHERE cal.calendar_code = org.calendar_code
309: AND cal.exception_set_id = org.calendar_exception_set_id
310: AND org.organization_id = p_organization_id
311: AND cal.seq_num is not null;

Line 358: mtl_parameters org

354: SELECT cal2.calendar_date
355: INTO l_return_date
356: FROM bom_calendar_dates cal1,
357: bom_calendar_dates cal2,
358: mtl_parameters org
359: WHERE cal1.calendar_code = org.calendar_code
360: AND cal1.exception_set_id = org.calendar_exception_set_id
361: AND cal1.calendar_date = TRUNC(p_date)
362: AND org.organization_id = p_organization_id

Line 375: mtl_parameters org

371: BEGIN
372: SELECT min(calendar_date), max(calendar_date)
373: INTO l_first_work_day, l_last_work_day
374: FROM BOM_CALENDAR_DATES cal,
375: mtl_parameters org
376: WHERE cal.calendar_code = org.calendar_code
377: AND cal.exception_set_id = org.calendar_exception_set_id
378: AND org.organization_id = p_organization_id
379: AND cal.seq_num is not null;

Line 3998: FROM MTL_PARAMETERS

3994: IF (p_calendar_type = MSC_CALENDAR.ORC OR p_calendar_type = MSC_CALENDAR.OSC) THEN
3995: -- Return OMC.
3996: SELECT calendar_code
3997: INTO l_calendar_code
3998: FROM MTL_PARAMETERS
3999: WHERE ORGANIZATION_ID = p_organization_id
4000: AND CALENDAR_EXCEPTION_SET_ID = -1;
4001: END IF;
4002: