eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on FND_USER

Line 218: Also there is a cartesian joint with fnd_user which is not required, hence removing it*/

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*/
219:
220: CURSOR c_access_level(cp_list_id NUMBER) IS -- Bug 2717635
221: SELECT MAX(access_level) access_level FROM (
222: SELECT access_level

Line 235: /* fnd_user u */ -- Bug 2717635

231: UNION ALL
232: SELECT access_level
233: FROM pa_dist_list_items i,
234: pa_project_parties p -- Bug 2717635
235: /* fnd_user u */ -- Bug 2717635
236: WHERE i.list_id = cp_list_id
237: AND i.recipient_type = 'PROJECT_ROLE'
238: AND p.project_role_id = i.recipient_id
239: AND p.resource_id = l_resource_id -- Bug 2717635

Line 318: --Bug# 4284420: Modified the cursor to avoid selecting end-dated fnd_users

314: FROM pa_object_dist_lists
315: WHERE object_type = p_object_type
316: AND object_id = p_object_id;
317:
318: --Bug# 4284420: Modified the cursor to avoid selecting end-dated fnd_users
319: CURSOR c_dist_list(cp_list_id NUMBER) IS
320: SELECT DISTINCT user_name, full_name, email_address FROM (
321: SELECT p.user_name user_name,
322: p.resource_source_name full_name,

Line 326: fnd_user u

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'
330: AND p.project_party_id = i.recipient_id

Line 342: fnd_user u

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'
346: AND p.project_role_id = i.recipient_id

Line 357: fnd_user u

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
361: AND i.recipient_type = 'ALL_PROJECT_PARTIES')

Line 373: fnd_user u

369: hzp.party_name full_name,
370: hzp.email_address email_address
371: FROM pa_dist_list_items i,
372: hz_parties hzp,
373: fnd_user u
374: WHERE i.list_id = cp_list_id
375: AND i.access_level >= p_access_level
376: AND i.recipient_type = 'HZ_PARTY'
377: AND hzp.party_id = i.recipient_id

Line 388: fnd_user u

384: per.full_name full_name,
385: per.email_address email_address
386: FROM pa_dist_list_items i,
387: per_all_people_f per,
388: fnd_user u
389: WHERE i.list_id = cp_list_id
390: AND i.access_level >= p_access_level
391: AND i.recipient_type = 'HZ_PARTY'
392: AND per.party_id = i.recipient_id

Line 505: fnd_user u

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'
509: AND p.project_party_id = i.recipient_id

Line 522: fnd_user u

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'
526: AND p.project_role_id = i.recipient_id

Line 539: fnd_user u

535: hzp.party_name full_name,
536: hzp.email_address email_address
537: FROM pa_dist_list_items i,
538: hz_parties hzp,
539: fnd_user u
540: WHERE i.list_id = cp_list_id
541: AND i.access_level >= p_access_level
542: AND i.recipient_type = 'HZ_PARTY'
543: AND hzp.party_id = i.recipient_id

Line 555: fnd_user u

551: per.full_name full_name,
552: per.email_address email_address
553: FROM pa_dist_list_items i,
554: per_all_people_f per,
555: fnd_user u
556: WHERE i.list_id = cp_list_id
557: AND i.access_level >= p_access_level
558: AND i.recipient_type = 'HZ_PARTY'
559: AND per.party_id = i.recipient_id

Line 581: fnd_user u

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
585: AND i.access_level >= p_access_level