APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_DIST_LIST_ITEMS

Line 664: FROM pa_dist_list_items i,

660: AND pc.planning_cycle = p_pcid;
661:
662: Cursor c_get_dlist_users IS
663: SELECT DISTINCT ppp.user_name, ppp.organization_id -- select to fetch persons attached to the role defined in the access list
664: FROM pa_dist_list_items i,
665: pa_project_parties_v ppp,
666: pa_object_dist_lists podl,
667: fnd_user u
668: WHERE i.recipient_type = 'PROJECT_ROLE'

Line 679: FROM pa_dist_list_items i,

675: and ppp.user_id = u.user_id
676: and trunc(sysdate) BETWEEN trunc(u.start_date) AND trunc(NVL(u.end_date,sysdate))
677: UNION
678: SELECT DISTINCT u.user_name, a.organization_id -- select to fetch persons defined in the access list
679: FROM pa_dist_list_items i,
680: pa_object_dist_lists podl,
681: hz_parties hzp,
682: fnd_user u,
683: per_all_assignments_f a, per_all_people_f p