DBA Data[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_OBJECT_DIST_LISTS

Line 666: pa_object_dist_lists podl,

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'
669: AND i.list_id = podl.list_id
670: AND podl.object_id = p_pcid

Line 680: pa_object_dist_lists podl,

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
684: WHERE i.recipient_type = 'HZ_PARTY'