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.

[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_OBJECT_DIST_LISTS

Line 661: pa_object_dist_lists podl

657: Cursor c_get_dlist_users IS
658: SELECT DISTINCT ppp.user_name, ppp.organization_id -- select to fetch persons attached to the role defined in the access list
659: FROM pa_dist_list_items i,
660: pa_project_parties_v ppp,
661: pa_object_dist_lists podl
662: WHERE i.recipient_type = 'PROJECT_ROLE'
663: AND i.list_id = podl.list_id
664: AND podl.object_id = p_pcid
665: AND podl.object_type = 'PJP_PLANNING_CYCLE'

Line 672: pa_object_dist_lists podl,

668: and ppp.user_id IS NOT NULL -- To prevent invalid user name error during workflow
669: UNION
670: SELECT DISTINCT u.user_name, a.organization_id -- select to fetch persons defined in the access list
671: FROM pa_dist_list_items i,
672: pa_object_dist_lists podl,
673: hz_parties hzp,
674: fnd_user u,
675: per_all_assignments_f a, per_all_people_f p
676: WHERE i.recipient_type = 'HZ_PARTY'