APPS.IBC_UTILITIES_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 138: temp JTF_RS_RESOURCE_EXTNS_TL.resource_name%TYPE;

134: jtf_rs_groups_vl
135: WHERE
136: group_id = f_resource_id;
137:
138: temp JTF_RS_RESOURCE_EXTNS_TL.resource_name%TYPE;
139: BEGIN
140: OPEN c_rn;
141: FETCH c_rn INTO temp;
142:

Line 1161: jtf_rs_resource_extns rsextn

1157: CURSOR Check_Group(p_user_id IN NUMBER, p_group_id IN NUMBER) IS
1158: SELECT 'X'
1159: FROM jtf_rs_groups_denorm rsgroup,
1160: jtf_rs_group_members rsmember,
1161: jtf_rs_resource_extns rsextn
1162: WHERE parent_group_id = p_group_id
1163: AND rsgroup.group_id = rsmember.group_id
1164: AND rsmember.delete_flag = 'N'
1165: AND rsextn.resource_id = rsmember.resource_id

Line 1170: FROM jtf_rs_resource_extns

1166: AND rsextn.user_id = p_user_id;
1167:
1168: CURSOR Check_Individual(p_user_id IN NUMBER, p_resource_id IN NUMBER) IS
1169: SELECT 'X'
1170: FROM jtf_rs_resource_extns
1171: WHERE resource_id = p_resource_id
1172: AND user_id = p_user_id;
1173:
1174: CURSOR Check_Responsibility(p_user_id IN NUMBER, p_resp_id IN NUMBER) IS