[Home] [Help]
4202: CURSOR get_pos_mandatory(c_path_position_id NUMBER) IS
4203: SELECT B.position_necessity_code
4204: FROM ahl_mc_path_position_nodes A,
4205: ahl_mc_relationships B,
4206: ahl_mc_headers_b C
4207: WHERE A.path_position_id = c_path_position_id
4208: and A.sequence = (select max(D.sequence)
4209: from ahl_mc_path_position_nodes D
4210: group by D.path_position_id