APPS.GMP_RSRC_AVL_PKG dependencies on GMP_RSRC_UNAVAIL_DTL_V

Line 136: FROM gmp_rsrc_unavail_dtl_v

132: CURSOR unavail_c2 IS
133: SELECT resource_units,
134: decode(sign(from_date - p_from_date),-1,p_from_date,from_date) from_time,
135: decode(sign(to_date - v_to_time),-1,to_date,v_to_time) to_time
136: FROM gmp_rsrc_unavail_dtl_v
137: WHERE resource_id = p_resource_id
138: AND
139: (
140: (from_date between p_from_date and v_to_time)