APPS.MSD_COMMON_UTILITIES dependencies on MSD_TIME

Line 1079: select /*+ CACHE */ decode(p_bucket_type, 9, day, 1, week_end_date, month_end_date) from msd_time

1075: 1 ----------> WEEK
1076: 2 ----------> MONTH
1077: */
1078: cursor c1 is
1079: select /*+ CACHE */ decode(p_bucket_type, 9, day, 1, week_end_date, month_end_date) from msd_time
1080: where
1081: calendar_type = p_calendar_type and
1082: calendar_code = p_calendar_code and
1083: p_date = day;

Line 1255: from msd_time

1251: 10,week_end_date,
1252: 11,month_end_date,
1253: 12,quarter_end_date,
1254: 13,year_end_date)
1255: from msd_time
1256: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1257: and calendar_code = P_CALENDAR_CODE
1258: and decode(P_TIME_LEVEL_ID,
1259: 1,week_end_date,

Line 1302: from msd_time

1298: 10,week_end_date,
1299: 11,month_end_date,
1300: 12,quarter_end_date,
1301: 13,year_end_date) bucket_date
1302: from msd_time
1303: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1304: and calendar_code = P_CALENDAR_CODE
1305: and decode(P_TIME_LEVEL_ID,
1306: 1,week_end_date,

Line 1337: from msd_time

1333: 10,week_end_date,
1334: 11,month_end_date,
1335: 12,quarter_end_date,
1336: 13,year_end_date) bucket_date
1337: from msd_time
1338: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1339: and calendar_code = P_CALENDAR_CODE
1340: and decode(P_TIME_LEVEL_ID,
1341: 1,week_end_date,

Line 1412: from msd_time

1408: 10,week_start_date,
1409: 11,month_start_date,
1410: 12,quarter_start_date,
1411: 13,year_start_date)
1412: from msd_time
1413: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1414: and calendar_code = P_CALENDAR_CODE
1415: and decode(P_TIME_LEVEL_ID,
1416: 1,week_start_date,

Line 1459: from msd_time

1455: 10,week_start_date,
1456: 11,month_start_date,
1457: 12,quarter_start_date,
1458: 13,year_start_date) bucket_date
1459: from msd_time
1460: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1461: and calendar_code = P_CALENDAR_CODE
1462: and decode(P_TIME_LEVEL_ID,
1463: 1,week_start_date,

Line 1494: from msd_time

1490: 10,week_start_date,
1491: 11,month_start_date,
1492: 12,quarter_start_date,
1493: 13,year_start_date) bucket_date
1494: from msd_time
1495: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1496: and calendar_code = P_CALENDAR_CODE
1497: and decode(P_TIME_LEVEL_ID,
1498: 1,week_start_date,

Line 1571: from msd_time

1567: 10,week_start_date,
1568: 11,month_start_date,
1569: 12,quarter_start_date,
1570: 13,year_start_date))
1571: from msd_time
1572: where calendar_type = decode(P_TIME_LEVEL_ID,1,2,2,2,3,3,4,3,5,3,6,1,7,1,8,1,10,4,11,4,12,4,13,4)
1573: and calendar_code = P_CALENDAR_CODE
1574: and decode(P_TIME_LEVEL_ID,
1575: 1,week_start_date,

Line 1698: msd_time mt,

1694: l_auth_percent number;
1695: begin
1696: select sum(mad.PERCENTAGE_PURCHASE_PRICE)/((p_period_end_date - p_period_start_date +1 )*100) into l_auth_percent
1697: from MSC_ASL_AUTH_DETAILS mad,
1698: msd_time mt,
1699: msd_demand_plans mdp
1700: where p_supplier_id = mad.supplier_id and
1701: p_sr_instance_id = mad.sr_instance_id and
1702: p_organization_id = mad.organization_id and