[Home] [Help]
69: CURSOR C_COA_DETAILS IS
70: SELECT
71: count(*)
72: FROM
73: GMD_COA_DETAILS;
74: CURSOR C_COA_SPEC_TEXT IS
75: SELECT
76: count(*)
77: FROM
99: FETCH C_COA_DETAILS
100: INTO L_COUNT;
101: CLOSE C_COA_DETAILS;
102: IF (L_COUNT > 0) THEN
103: DELETE FROM GMD_COA_DETAILS;
104: END IF;
105: OPEN C_COA_SPEC_TEXT;
106: FETCH C_COA_SPEC_TEXT
107: INTO L_COUNT;