APPS.IGW_SECURITY dependencies on IGW_ROLE_RIGHTS

Line 51: igw_role_rights rr

47:
48: SELECT distinct 'X'
49: INTO l_dummy
50: FROM igw_prop_user_roles ur,
51: igw_role_rights rr
52: WHERE ur.proposal_id = p_proposal_id
53: AND ur.user_id = p_user_id
54: AND rr.role_id = ur.role_id
55: AND rr.right_code in ('MODIFY_GENERAL');

Line 68: igw_role_rights rr

64:
65: SELECT distinct 'X'
66: INTO l_dummy
67: FROM igw_prop_user_roles ur,
68: igw_role_rights rr
69: WHERE ur.proposal_id = p_proposal_id
70: AND ur.user_id = p_user_id
71: AND rr.role_id = ur.role_id
72: AND rr.right_code in ('MODIFY_BUDGET');

Line 85: igw_role_rights rr

81:
82: SELECT distinct 'X'
83: INTO l_dummy
84: FROM igw_prop_user_roles ur,
85: igw_role_rights rr
86: WHERE ur.proposal_id = p_proposal_id
87: AND ur.user_id = p_user_id
88: AND rr.role_id = ur.role_id
89: AND rr.right_code in ('MODIFY_NARRATIVE');

Line 102: igw_role_rights rr

98:
99: SELECT distinct 'X'
100: INTO l_dummy
101: FROM igw_prop_user_roles ur,
102: igw_role_rights rr
103: WHERE ur.proposal_id = p_proposal_id
104: AND ur.user_id = p_user_id
105: AND rr.role_id = ur.role_id
106: AND rr.right_code in ('MODIFY_CHECKLIST');

Line 119: igw_role_rights rr

115:
116: SELECT distinct 'X'
117: INTO l_dummy
118: FROM igw_prop_user_roles ur,
119: igw_role_rights rr
120: WHERE ur.proposal_id = p_proposal_id
121: AND ur.user_id = p_user_id
122: AND rr.role_id = ur.role_id
123: AND rr.right_code in ('MODIFY_APPROVAL');

Line 136: igw_role_rights rr

132:
133: SELECT distinct 'X'
134: INTO l_dummy
135: FROM igw_prop_user_roles ur,
136: igw_role_rights rr
137: WHERE ur.proposal_id = p_proposal_id
138: AND ur.user_id = p_user_id
139: AND rr.role_id = ur.role_id
140: AND rr.right_code in ('MODIFY_SPONSOR_ACTION');

Line 153: igw_role_rights rr

149:
150: SELECT distinct 'X'
151: INTO l_dummy
152: FROM igw_prop_user_roles ur,
153: igw_role_rights rr
154: WHERE ur.proposal_id = p_proposal_id
155: AND ur.user_id = p_user_id
156: AND rr.role_id = ur.role_id
157: AND rr.right_code in ('MODIFY_AWARD');

Line 170: igw_role_rights rr

166:
167: SELECT distinct 'X'
168: INTO l_dummy
169: FROM igw_prop_user_roles ur,
170: igw_role_rights rr
171: WHERE ur.proposal_id = p_proposal_id
172: AND ur.user_id = p_user_id
173: AND rr.role_id = ur.role_id
174: AND rr.right_code in ('PRINT_PROPOSAL');

Line 217: igw_role_rights prr

213:
214: select distinct 'X'
215: into l_dummy
216: from igw_prop_user_roles ppur,
217: igw_role_rights prr
218: where ppur.role_id = prr.role_id
219: and ppur.proposal_id = p_proposal_id
220: and ppur.user_id = p_user_id
221: and prr.right_code in