[Home] [Help]
5: CURSOR CUR_PARENT_NUM IS
6: SELECT
7: NAME
8: FROM
9: QP_LIST_HEADERS_VL
10: WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
11: BEGIN
12: OPEN CUR_PARENT_NUM;
13: FETCH CUR_PARENT_NUM
21: CURSOR CUR_VERSION IS
22: SELECT
23: VERSION_NO
24: FROM
25: QP_LIST_HEADERS_VL
26: WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
27: BEGIN
28: OPEN CUR_VERSION;
29: FETCH CUR_VERSION