APPS.IGS_GE_GEN_001 dependencies on USER_CONSTRAINTS

Line 42: cp_table_name user_constraints.table_name%TYPE) IS

38: FROM user_col_comments ucc
39: WHERE ucc.table_name = cp_view_name AND
40: ucc.column_name = cp_column_name;
41: CURSOR c_uc (
42: cp_table_name user_constraints.table_name%TYPE) IS
43: SELECT uc.search_condition
44: FROM user_constraints uc
45: WHERE uc.constraint_type = 'C' AND
46: uc.table_name = cp_table_name AND

Line 44: FROM user_constraints uc

40: ucc.column_name = cp_column_name;
41: CURSOR c_uc (
42: cp_table_name user_constraints.table_name%TYPE) IS
43: SELECT uc.search_condition
44: FROM user_constraints uc
45: WHERE uc.constraint_type = 'C' AND
46: uc.table_name = cp_table_name AND
47: uc.status = 'ENABLED' AND
48: uc.constraint_name like '%UCASE_CK%';