8: p_user_id IN NUMBER DEFAULT 0)
9: IS
10: CURSOR c1(l_schema IN VARCHAR2) IS
11: SELECT 'Y'
12: FROM sys.all_tab_columns
13: WHERE table_name = 'HZ_CLASS_CATEGORIES'
14: AND column_name = 'ALLOW_LEAF_NODE_ONLY_FLAG'
15: AND owner = l_schema;
16:
148: p_user_id IN NUMBER DEFAULT 0)
149: IS
150: CURSOR c1(l_schema IN VARCHAR2) IS
151: SELECT 'Y'
152: FROM sys.all_tab_columns
153: WHERE table_name = 'HZ_CLASS_CATEGORY_USES'
154: AND column_name = 'ADDITIONAL_WHERE_CLAUSE'
155: AND owner = l_schema;
156: