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 185: Also there is a cartesian joint with fnd_user which is not required, hence removing it*/

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*/
186:
187: CURSOR c_access_level(cp_list_id NUMBER) IS -- Bug 2717635
188: SELECT MAX(access_level) access_level FROM (
189: SELECT access_level

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

198: UNION ALL
199: SELECT access_level
200: FROM pa_dist_list_items i,
201: pa_project_parties p -- Bug 2717635
202: /* fnd_user u */ -- Bug 2717635
203: WHERE i.list_id = cp_list_id
204: AND i.recipient_type = 'PROJECT_ROLE'
205: AND p.project_role_id = i.recipient_id
206: AND p.resource_id = l_resource_id -- Bug 2717635

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

281: FROM pa_object_dist_lists
282: WHERE object_type = p_object_type
283: AND object_id = p_object_id;
284:
285: --Bug# 4284420: Modified the cursor to avoid selecting end-dated fnd_users
286: CURSOR c_dist_list(cp_list_id NUMBER) IS
287: SELECT DISTINCT user_name, full_name, email_address FROM (
288: SELECT p.user_name user_name,
289: p.resource_source_name full_name,

Line 293: fnd_user u

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

Line 309: fnd_user u

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

Line 324: fnd_user u

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

Line 340: fnd_user u

336: hzp.party_name full_name,
337: hzp.email_address email_address
338: FROM pa_dist_list_items i,
339: hz_parties hzp,
340: fnd_user u
341: WHERE i.list_id = cp_list_id
342: AND i.access_level >= p_access_level
343: AND i.recipient_type = 'HZ_PARTY'
344: AND hzp.party_id = i.recipient_id

Line 355: fnd_user u

351: per.full_name full_name,
352: per.email_address email_address
353: FROM pa_dist_list_items i,
354: per_all_people_f per,
355: fnd_user u
356: WHERE i.list_id = cp_list_id
357: AND i.access_level >= p_access_level
358: AND i.recipient_type = 'HZ_PARTY'
359: AND per.party_id = i.recipient_id

Line 472: fnd_user u

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

Line 489: fnd_user u

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

Line 506: fnd_user u

502: hzp.party_name full_name,
503: hzp.email_address email_address
504: FROM pa_dist_list_items i,
505: hz_parties hzp,
506: fnd_user u
507: WHERE i.list_id = cp_list_id
508: AND i.access_level >= p_access_level
509: AND i.recipient_type = 'HZ_PARTY'
510: AND hzp.party_id = i.recipient_id

Line 522: fnd_user u

518: per.full_name full_name,
519: per.email_address email_address
520: FROM pa_dist_list_items i,
521: per_all_people_f per,
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 = 'HZ_PARTY'
526: AND per.party_id = i.recipient_id

Line 548: fnd_user u

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