[Home] [Help]
177: WHERE object_type = p_object_type
178: AND object_id = p_object_id;
179:
180: /* Bug 2717635 in the following query, selected from table pa_project_parties
181: in place of view pa_project_parties_v to improve the performance
182: Also passed another parameter to this cursor c_access_level ie
183: cp_resource_id which passes the resource_id for a corresponding user_id
184: for join with table pa_project_parties
185: Also there is a cartesian joint with fnd_user which is not required, hence removing it*/
288: SELECT p.user_name user_name,
289: p.resource_source_name full_name,
290: p.email_address email_address
291: FROM pa_dist_list_items i,
292: pa_project_parties_v p,
293: fnd_user u
294: WHERE i.list_id = cp_list_id
295: AND i.access_level >= p_access_level
296: AND i.recipient_type = 'PROJECT_PARTY'
304: SELECT p.user_name user_name,
305: p.resource_source_name full_name,
306: p.email_address email_address
307: FROM pa_dist_list_items i,
308: pa_project_parties_v p,
309: fnd_user u
310: WHERE i.list_id = cp_list_id
311: AND i.access_level >= p_access_level
312: AND i.recipient_type = 'PROJECT_ROLE'
319: UNION ALL
320: SELECT p.user_name user_name,
321: p.resource_source_name full_name,
322: p.email_address email_address
323: FROM pa_project_parties_v p,
324: fnd_user u
325: WHERE EXISTS (SELECT 1 FROM pa_dist_list_items i
326: WHERE i.list_id = cp_list_id
327: AND i.access_level >= p_access_level
467: SELECT p.user_name user_name,
468: p.resource_source_name full_name,
469: p.email_address email_address
470: FROM pa_dist_list_items i,
471: pa_project_parties_v p,
472: fnd_user u
473: WHERE i.list_id = cp_list_id
474: AND i.access_level >= p_access_level
475: AND i.recipient_type = 'PROJECT_PARTY'
484: SELECT p.user_name user_name,
485: p.resource_source_name full_name,
486: p.email_address email_address
487: FROM pa_dist_list_items i,
488: pa_project_parties_v p,
489: fnd_user u
490: WHERE i.list_id = cp_list_id
491: AND i.access_level >= p_access_level
492: AND i.recipient_type = 'PROJECT_ROLE'
543: UNION ALL
544: SELECT DISTINCT p.user_name user_name,
545: p.resource_source_name full_name,
546: p.email_address email_address
547: FROM pa_project_parties_v p,
548: fnd_user u
549: WHERE EXISTS ( SELECT 1
550: FROM pa_dist_list_items i
551: WHERE i.list_id = cp_list_id