DBA Data[Home] [Help]

APPS.GCS_LEX_MAP_API_PKG dependencies on USER_OBJECTS

Line 2176: FROM user_objects

2172: PRAGMA AUTONOMOUS_TRANSACTION;
2173:
2174: CURSOR all_funcs IS
2175: SELECT object_name
2176: FROM user_objects
2177: WHERE object_name LIKE
2178: 'GCS\_LEX\_GET\_' || p_rule_set_id || '\__%' ESCAPE '\'
2179: AND object_name NOT IN
2180: (SELECT 'GCS_LEX_GET_' || p_rule_set_id || '_' || r.rule_id

Line 2743: FROM user_objects

2739: AND r.target_column_id = mc.column_id;
2740:
2741: CURSOR check_func_c(c_func_name VARCHAR2) IS
2742: SELECT 1
2743: FROM user_objects
2744: WHERE object_name = c_func_name;
2745:
2746: func_name VARCHAR2(50);
2747: dummy NUMBER;

Line 3763: FROM user_objects

3759: ORDER BY rstg.stage_number;
3760:
3761: CURSOR check_func_c(c_func_name VARCHAR2) IS
3762: SELECT 1
3763: FROM user_objects
3764: WHERE object_name = c_func_name;
3765:
3766: dummy NUMBER;
3767: