[Home] [Help]
93: CURSOR CUR_PARENT_NUM IS
94: SELECT
95: NAME
96: FROM
97: QP_LIST_HEADERS_VL
98: WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
99: BEGIN
100: OPEN CUR_PARENT_NUM;
101: FETCH CUR_PARENT_NUM
109: CURSOR CUR_VERSION IS
110: SELECT
111: VERSION_NO
112: FROM
113: QP_LIST_HEADERS_VL
114: WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
115: BEGIN
116: OPEN CUR_VERSION;
117: FETCH CUR_VERSION