APPS.WIP_WS_LABOR_METRIC_PUB dependencies on FND_DATE

Line 328: and fnd_date.canonical_to_date(to_char((bsd.shift_date + st.to_time/(60*60*24)),WIP_CONSTANTS.DATETIME_FMT)) < end_period

324: and bsd.shift_num = st.shift_num
325: and bsd.seq_num is not null
326: and bsd.calendar_code = bcs.calendar_code
327: and bsd.shift_num = bcs.shift_num
328: and fnd_date.canonical_to_date(to_char((bsd.shift_date + st.to_time/(60*60*24)),WIP_CONSTANTS.DATETIME_FMT)) < end_period
329: and brs.shift_num= bcs.shift_num
330: and brs.department_id = dept_id
331: and brs.resource_id = res_id;
332: