APPS.IGS_SC_GEN_001 dependencies on IGS_SC_OBJ_ATTRIBS

Line 139: l_obj_attrib igs_sc_obj_attribs%ROWTYPE;

135: l_statment VARCHAR2(32000); -- Grant statment
136: l_stat_found BOOLEAN := FALSE;
137: l_grant_cond g_grant_conds_t;
138: l_user_attrib igs_sc_usr_attribs%ROWTYPE;
139: l_obj_attrib igs_sc_obj_attribs%ROWTYPE;
140: l_cur_pos NUMBER(10);
141: l_found_pos NUMBER(10);
142: l_cur_num NUMBER(1);
143: l_alias_name VARCHAR2(8);

Line 208: FROM igs_sc_obj_attribs

204: WHERE user_attrib_id = s_attrib_id;
205:
206: CURSOR c_obj_attrib ( s_obj_attrib_id NUMBER, s_obj_group_id NUMBER) IS
207: SELECT *
208: FROM igs_sc_obj_attribs
209: WHERE obj_group_id = s_obj_group_id
210: AND obj_attrib_id= s_obj_attrib_id;
211:
212: CURSOR def_grnt(p_obj_name VARCHAR2)