87: /* Cursor to get the column hierarchy for a given activity */
88:
89: CURSOR Cur_Actcol_wf(X_activity_id NUMBER) IS
90: SELECT COLUMN_NAME
91: FROM gma_actcol_wf_b
92: WHERE activity_id = X_activity_id
93: ORDER BY Column_hierarchy;
94:
95: /* Cursot to fetch a role for the given attributes */
833: /* Cursor to get the column hierarchy for a given activity */
834:
835: CURSOR Cur_Actcol_wf(X_activity_id NUMBER) IS
836: SELECT COLUMN_NAME
837: FROM gma_actcol_wf_b
838: WHERE activity_id = X_activity_id
839: ORDER BY Column_hierarchy;
840:
841: /* Cursot to fetch a role for the given attributes */