APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_DIST_LIST_ITEMS

Line 659: FROM pa_dist_list_items i,

655: AND pc.planning_cycle = p_pcid;
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

Line 671: FROM pa_dist_list_items i,

667: AND ppp.project_role_id = i.recipient_id
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