DBA Data[Home] [Help]

APPS.IGS_SC_GEN_001 dependencies on IGS_SC_USR_ATTRIBS

Line 138: l_user_attrib igs_sc_usr_attribs%ROWTYPE;

134: ------------------------------------------------------------------
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);

Line 203: FROM igs_sc_usr_attribs

199:
200: -- Get user attributes.
201: CURSOR c_user_attrib (s_attrib_id NUMBER) IS
202: SELECT *
203: FROM igs_sc_usr_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 *