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 180: /* Bug 2717635 in the following query, selected from table pa_project_parties

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

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

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

Line 184: for join with table pa_project_parties

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

Line 191: pa_project_parties p -- Bug 2717635

187: CURSOR c_access_level(cp_list_id NUMBER) IS -- Bug 2717635
188: SELECT MAX(access_level) access_level FROM (
189: SELECT access_level
190: FROM pa_dist_list_items i,
191: pa_project_parties p -- Bug 2717635
192: WHERE i.list_id = cp_list_id
193: AND i.recipient_type = 'PROJECT_PARTY'
194: AND p.project_party_id = i.recipient_id
195: AND p.resource_id = l_resource_id -- Bug 2717635

Line 201: pa_project_parties p -- Bug 2717635

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

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

210: SELECT access_level
211: FROM pa_dist_list_items
212: WHERE list_id = cp_list_id
213: AND recipient_type = 'ALL_PROJECT_PARTIES'
214: AND EXISTS (SELECT 'Y' FROM pa_project_parties -- Bug 2717635
215: WHERE resource_id = l_resource_id -- Bug 2717635
216: AND object_type = l_object_type
217: AND object_id = l_object_id)
218: UNION ALL

Line 292: pa_project_parties_v p,

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'

Line 308: pa_project_parties_v p,

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'

Line 323: FROM pa_project_parties_v p,

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

Line 471: pa_project_parties_v p,

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'

Line 488: pa_project_parties_v p,

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'

Line 547: FROM pa_project_parties_v p,

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

Line 667: FROM pa_project_parties a, pa_project_parties b

663: WHERE object_type = p_object_type_to
664: AND object_id = p_object_id_to;
665:
666: CURSOR get_project_party_to IS SELECT b.project_party_id
667: FROM pa_project_parties a, pa_project_parties b
668: WHERE a.project_party_id = l_recipient_id
669: AND b.object_type = a.object_type
670: AND b.object_id = l_object_id
671: AND b.resource_type_id = a.resource_type_id