DBA Data[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_PROJECT_PARTIES

Line 634: FROM pa_project_parties ppp,

630: -- Also verify the user has an active assignment as of sysdate .
631:
632: CURSOR c_get_port_users IS
633: SELECT DISTINCT u.user_name, prd.organization_id
634: FROM pa_project_parties ppp,
635: pa_project_role_types pprt,
636: per_all_people_f pe,
637: per_all_assignments_f prd,
638: fnd_user u ,

Line 660: pa_project_parties_v ppp,

656:
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