DBA Data[Home] [Help]

APPS.MRP_WB_BUCKET_DATES dependencies on BOM_CAL_WEEK_START_DATES

Line 183: FROM bom_cal_week_start_dates

179: -- beginning of the week that include var_the_date
180: -- -----------------------------------------------------------------
181: DECLARE CURSOR WEEKS IS
182: SELECT week_start_date
183: FROM bom_cal_week_start_dates
184: WHERE calendar_code = var_calendar_code
185: AND exception_set_id = var_exception_set_id
186: AND seq_num IS NOT NULL
187: AND week_start_date >= var_the_date + DECODE(counter, 0, 0, 1)