APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_OBJ_ATT_VALS

Line 56: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,

52: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
53: condition igs_sc_grant_conds.condition%TYPE,
54: text_value igs_sc_grant_conds.text_value%TYPE,
55: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
56: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,
57: cond_text VARCHAR2(2000),
58: z_typ_flag VARCHAR2(1) --mmkumar
59: );
60:

Line 793: -- (select pk1_value,pk2_value,.. from igs_sc_obj_att_vals where object_id= ..

789: ELSIF l_obj_attrib.obj_attrib_type IN ('S','F') AND l_obj_attrib.static_type IN ('C') THEN
790:
791: -- Attribute static and Select or function type - use select from attributes table
792: -- final will look like (pk_column1,pk_column2,..) IN
793: -- (select pk1_value,pk2_value,.. from igs_sc_obj_att_vals where object_id= ..
794: -- AND obj_attrib_id = ... AND value =..)
795: -- Construct first part with PK
796: l_alias_name := get_alias;
797:

Line 828: l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text := l_part_grant||l_part_grant2||' FROM igs_sc_obj_att_vals '||l_alias_name

824:
825: END IF;
826:
827:
828: l_grant_cond(c_grant_cond_rec.grant_cond_num).cond_text := l_part_grant||l_part_grant2||' FROM igs_sc_obj_att_vals '||l_alias_name
829: ||' WHERE '||l_alias_name||'.object_id='||p_group_rec.object_id
830: ||' AND '||l_alias_name||'.obj_attrib_id='||l_grant_cond(c_grant_cond_rec.grant_cond_num).obj_attrib_id ||' AND '
831: ||l_alias_name||'.attr_value '||l_grant_cond(c_grant_cond_rec.grant_cond_num).condition||' ';
832: