[Home] [Help]
210: WHERE object_type = p_object_type
211: AND object_id = p_object_id;
212:
213: /* Bug 2717635 in the following query, selected from table pa_project_parties
214: in place of view pa_project_parties_v to improve the performance
215: Also passed another parameter to this cursor c_access_level ie
216: cp_resource_id which passes the resource_id for a corresponding user_id
217: for join with table pa_project_parties
218: Also there is a cartesian joint with fnd_user which is not required, hence removing it*/
321: SELECT p.user_name user_name,
322: p.resource_source_name full_name,
323: p.email_address email_address
324: FROM pa_dist_list_items i,
325: pa_project_parties_v p,
326: fnd_user u
327: WHERE i.list_id = cp_list_id
328: AND i.access_level >= p_access_level
329: AND i.recipient_type = 'PROJECT_PARTY'
337: SELECT p.user_name user_name,
338: p.resource_source_name full_name,
339: p.email_address email_address
340: FROM pa_dist_list_items i,
341: pa_project_parties_v p,
342: fnd_user u
343: WHERE i.list_id = cp_list_id
344: AND i.access_level >= p_access_level
345: AND i.recipient_type = 'PROJECT_ROLE'
352: UNION ALL
353: SELECT p.user_name user_name,
354: p.resource_source_name full_name,
355: p.email_address email_address
356: FROM pa_project_parties_v p,
357: fnd_user u
358: WHERE EXISTS (SELECT 1 FROM pa_dist_list_items i
359: WHERE i.list_id = cp_list_id
360: AND i.access_level >= p_access_level
500: SELECT p.user_name user_name,
501: p.resource_source_name full_name,
502: p.email_address email_address
503: FROM pa_dist_list_items i,
504: pa_project_parties_v p,
505: fnd_user u
506: WHERE i.list_id = cp_list_id
507: AND i.access_level >= p_access_level
508: AND i.recipient_type = 'PROJECT_PARTY'
517: SELECT p.user_name user_name,
518: p.resource_source_name full_name,
519: p.email_address email_address
520: FROM pa_dist_list_items i,
521: pa_project_parties_v p,
522: fnd_user u
523: WHERE i.list_id = cp_list_id
524: AND i.access_level >= p_access_level
525: AND i.recipient_type = 'PROJECT_ROLE'
576: UNION ALL
577: SELECT DISTINCT p.user_name user_name,
578: p.resource_source_name full_name,
579: p.email_address email_address
580: FROM pa_project_parties_v p,
581: fnd_user u
582: WHERE EXISTS ( SELECT 1
583: FROM pa_dist_list_items i
584: WHERE i.list_id = cp_list_id