[Home] [Help]
1874: p_subinventory_code varchar2)
1875: return date is
1876: cursor business_days is
1877: select trunc(sysdate+flvv.lookup_code) bd_arrival_date
1878: FROM jtf_cal_shift_constructs jcsc,
1879: jtf_cal_shifts_b jcsb,
1880: jtf_cal_shift_assign jcsa,
1881: jtf_calendars_b jcb,
1882: fnd_lookup_values_vl flvv,