APPS.WIP_WS_LABOR_METRIC_PUB dependencies on FND_DATE

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

333: and bsd.shift_num = bcs.shift_num
334: /*Fix bug 14674233, shouldn't use the operator < because it should be inclusive of end_period
335: end period is the last shift before sysdate and was retrieved by get_period_end(). So, if we
336: used operator < instead of <=, the last shift will be considered as part of labor metric calculation*/
337: and fnd_date.canonical_to_date(to_char((bsd.shift_date + st.to_time/(60*60*24)),WIP_CONSTANTS.DATETIME_FMT)) <= end_period
338: and brs.shift_num= bcs.shift_num
339: and brs.department_id = dept_id
340: and brs.resource_id = res_id;
341: