78: decode(brc.action_type,2,nvl(brc.to_date,g_cutoff_date),
79: 3,cal.prior_date,brc.from_date),
80: 2,
81: SYSDATE,
82: FND_GLOBAL.USER_ID,
83: SYSDATE,
84: FND_GLOBAL.USER_ID,
85: FND_GLOBAL.LOGIN_ID
86: FROM bom_resources res,
80: 2,
81: SYSDATE,
82: FND_GLOBAL.USER_ID,
83: SYSDATE,
84: FND_GLOBAL.USER_ID,
85: FND_GLOBAL.LOGIN_ID
86: FROM bom_resources res,
87: bom_departments dept,
88: bom_shift_times shifts,
81: SYSDATE,
82: FND_GLOBAL.USER_ID,
83: SYSDATE,
84: FND_GLOBAL.USER_ID,
85: FND_GLOBAL.LOGIN_ID
86: FROM bom_resources res,
87: bom_departments dept,
88: bom_shift_times shifts,
89: mtl_parameters mp,