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 PA_PROJECT_PARTIES

Line 213: /* Bug 2717635 in the following query, selected from table pa_project_parties

209: FROM pa_object_dist_lists
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

Line 214: in place of view pa_project_parties_v to improve the performance

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*/

Line 217: for join with table pa_project_parties

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

Line 224: pa_project_parties p -- Bug 2717635

220: CURSOR c_access_level(cp_list_id NUMBER) IS -- Bug 2717635
221: SELECT MAX(access_level) access_level FROM (
222: SELECT access_level
223: FROM pa_dist_list_items i,
224: pa_project_parties p -- Bug 2717635
225: WHERE i.list_id = cp_list_id
226: AND i.recipient_type = 'PROJECT_PARTY'
227: AND p.project_party_id = i.recipient_id
228: AND p.resource_id = l_resource_id -- Bug 2717635

Line 234: pa_project_parties p -- Bug 2717635

230: AND p.object_id = l_object_id
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

Line 247: AND EXISTS (SELECT 'Y' FROM pa_project_parties -- Bug 2717635

243: SELECT access_level
244: FROM pa_dist_list_items
245: WHERE list_id = cp_list_id
246: AND recipient_type = 'ALL_PROJECT_PARTIES'
247: AND EXISTS (SELECT 'Y' FROM pa_project_parties -- Bug 2717635
248: WHERE resource_id = l_resource_id -- Bug 2717635
249: AND object_type = l_object_type
250: AND object_id = l_object_id)
251: UNION ALL

Line 325: pa_project_parties_v p,

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'

Line 341: pa_project_parties_v p,

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'

Line 356: FROM pa_project_parties_v p,

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

Line 504: pa_project_parties_v p,

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'

Line 521: pa_project_parties_v p,

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'

Line 580: FROM pa_project_parties_v p,

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

Line 700: FROM pa_project_parties a, pa_project_parties b

696: WHERE object_type = p_object_type_to
697: AND object_id = p_object_id_to;
698:
699: CURSOR get_project_party_to IS SELECT b.project_party_id
700: FROM pa_project_parties a, pa_project_parties b
701: WHERE a.project_party_id = l_recipient_id
702: AND b.object_type = a.object_type
703: AND b.object_id = l_object_id
704: AND b.resource_type_id = a.resource_type_id