[Home] [Help]
1252: where requirement_header_id = p_search_params.requirement_header_id;
1253:
1254: cursor c_req_line_details(p_requirement_line_id number) is
1255: select source_type, source_id
1256: from csp_req_line_details
1257: where requirement_line_id = p_requirement_line_id;
1258:
1259: cursor c_reservations(p_reservation_id number) is
1260: select reservation_quantity