APPS.IGS_SC_GEN_001 dependencies on IGS_SC_USR_ATT_VALS

Line 29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,

25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
27: condition igs_sc_grant_conds.condition%TYPE,
28: text_value igs_sc_grant_conds.text_value%TYPE,
29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
30: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,
31: cond_text VARCHAR2(4000),
32: obj_const VARCHAR2(4000),
33: close_part VARCHAR2(100),

Line 579: l_usr_select :='SELECT '||l_usr_alias||'.attr_value FROM igs_sc_usr_att_vals '||l_usr_alias||' WHERE '||l_usr_alias||'.user_id=igs_sc_vars.get_userid AND '

575:
576: ELSIF l_user_attrib.user_attrib_type = 'M' THEN
577: -- If yes then construct for multi-value attribute
578: -- Add select from values table
579: l_usr_select :='SELECT '||l_usr_alias||'.attr_value FROM igs_sc_usr_att_vals '||l_usr_alias||' WHERE '||l_usr_alias||'.user_id=igs_sc_vars.get_userid AND '
580: ||l_usr_alias||'.user_attrib_id='||c_grant_cond_rec.user_attrib_id;
581: ELSE
582: --Simply get value for an attribute using API and append
583: l_usr_const := 'igs_sc_vars.get_att('||c_grant_cond_rec.user_attrib_id||')';