Line 1110: SELECT fnd_date.chardt_to_date(p_del_pickup_date_low)
1106: --{
1107: -- pick up dates
1108: IF (p_del_pickup_date_low IS NOT NULL) THEN
1109: --{ 1110: SELECT fnd_date.chardt_to_date(p_del_pickup_date_low) 1111: INTO l_del_pickup_date_low
1112: FROM dual;
1113: --}
1114: END IF;
Line 1117: SELECT fnd_date.chardt_to_date(p_del_pickup_date_high)
1113: --}
1114: END IF;
1115: IF (p_del_pickup_date_high IS NOT NULL) THEN
1116: --{ 1117: SELECT fnd_date.chardt_to_date(p_del_pickup_date_high) 1118: INTO l_del_pickup_date_high
1119: FROM dual;
1120: --}
1121: END IF;