APPS.MSD_PULL_TIME_DATA dependencies on MSD_ST_TIME

Line 23: from msd_st_time

19: calendar_code,
20: calendar_type,
21: min(day) min_day,
22: max(day) max_day
23: from msd_st_time
24: where instance <> '0'
25: group by instance, calendar_code, calendar_type;
26: Begin
27:

Line 46: Delete from msd_st_time

42: p_from_date => Calendar_Rec.min_day,
43: p_to_date => Calendar_Rec.max_day ) ;
44:
45:
46: Delete from msd_st_time
47: where instance = Calendar_Rec.instance
48: and calendar_code = Calendar_Rec.calendar_code
49: and calendar_type = Calendar_Rec.calendar_type
50: and day between Calendar_Rec.min_day and Calendar_Rec.max_day ;

Line 58: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_TIME',null);

54: End Loop ;
55:
56: /* Added by esubrama */
57: MSD_ANALYZE_TABLES.analyze_table('MSD_TIME',null);
58: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_TIME',null);
59:
60: exception
61:
62: when others then