APPS.MRP_REPPERIODS_PUB dependencies on BOM_CALENDAR_DATES

Line 45: FROM bom_calendar_dates

41:
42: -- Get the last date in this calendar
43: SELECT MAX(calendar_date)
44: INTO var_max_date
45: FROM bom_calendar_dates
46: WHERE calendar_code = var_calendar_code
47: AND exception_set_id = var_exception_set_id
48: AND seq_num IS NOT NULL;
49:

Line 106: FROM bom_calendar_dates

102:
103: BEGIN
104: SELECT next_date
105: INTO var_curr_workday
106: FROM bom_calendar_dates
107: WHERE calendar_code = var_calendar_code
108: AND exception_set_id = var_exception_set_id
109: AND calendar_date = var_curr_date;
110: EXCEPTION

Line 207: FROM bom_calendar_dates

203: -- workday. We'll delete those that are not updated in the next step.
204: UPDATE mrp_repetitive_periods s
205: SET period_start_date =
206: (SELECT next_date
207: FROM bom_calendar_dates
208: WHERE calendar_code = var_calendar_code
209: AND exception_set_id = var_exception_set_id
210: AND calendar_date = s.period_start_date)
211: WHERE EXISTS

Line 213: FROM bom_calendar_dates d

209: AND exception_set_id = var_exception_set_id
210: AND calendar_date = s.period_start_date)
211: WHERE EXISTS
212: (SELECT NULL
213: FROM bom_calendar_dates d
214: WHERE NOT EXISTS
215: (SELECT NULL
216: FROM mrp_repetitive_periods
217: WHERE organization_id = s.organization_id

Line 229: FROM bom_calendar_dates d

225: DELETE FROM mrp_repetitive_periods s
226: WHERE organization_id = arg_org_id
227: AND EXISTS
228: (SELECT NULL
229: FROM bom_calendar_dates d
230: WHERE seq_num IS NULL
231: AND calendar_code = var_calendar_code
232: AND exception_set_id = var_exception_set_id
233: AND calendar_date = s.period_start_date);