APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_USR_ATTRIBS

Line 615: l_user_attrib igs_sc_usr_attribs%ROWTYPE;

611: IS
612: l_statment VARCHAR2(4000); -- Grant statment
613: l_stat_found BOOLEAN := false;
614: l_grant_cond g_grant_conds_t;
615: l_user_attrib igs_sc_usr_attribs%ROWTYPE;
616: l_obj_attrib igs_sc_obj_att_mths%ROWTYPE;
617: l_cur_pos NUMBER(10);
618: l_found_pos NUMBER(10);
619: l_cur_num NUMBER(1);

Line 657: FROM igs_sc_usr_attribs

653: WHERE grant_id = s_grant_id;
654:
655: CURSOR c_user_attrib (s_attrib_id NUMBER) IS
656: SELECT *
657: FROM igs_sc_usr_attribs
658: WHERE user_attrib_id = s_attrib_id;
659:
660: CURSOR c_obj_attrib (s_attrib_id NUMBER, s_object_id NUMBER) IS
661: SELECT *

Line 1422: FROM igs_sc_usr_attribs

1418: user_attrib_name ,
1419: user_attrib_type ,
1420: static_type ,
1421: select_text
1422: FROM igs_sc_usr_attribs
1423: WHERE user_attrib_id = p_attrib_id
1424: OR ( p_attrib_id IS NULL AND
1425: (static_type = 'S'
1426: OR (static_type = 'C' AND p_all_attribs = 'Y') )

Line 1436: FROM igs_sc_usr_attribs

1432: user_attrib_name ,
1433: user_attrib_type ,
1434: static_type ,
1435: select_text
1436: FROM igs_sc_usr_attribs
1437: WHERE user_attrib_id = p_attrib_id;
1438:
1439: -- skpandey, Bug#4937960: Changed c_user definition to optimize query
1440: CURSOR c_users IS