Line 655: l_date := FND_DATE.CHARDATE_TO_DATE(p_date);
651: WHERE l_is_date between start_date and end_date;
652:
653: BEGIN
654: 655: l_date := FND_DATE.CHARDATE_TO_DATE(p_date); 656:
657: -- get the week id and week start date of the p_date parameter
658: /*
659: select week_id, week_start_date