DBA Data[Home] [Help]

APPS.FPA_MAIN_PROCESS_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 641: per_all_assignments_f prd,

637: SELECT DISTINCT u.user_name, prd.organization_id
638: FROM pa_project_parties ppp,
639: pa_project_role_types pprt,
640: per_all_people_f pe,
641: per_all_assignments_f prd,
642: fnd_user u ,
643: FPA_AW_PC_INFO_V pc
644: WHERE ppp.resource_type_id = 101
645: AND ppp.project_role_id = pprt.project_role_id

Line 683: per_all_assignments_f a, per_all_people_f p

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'
685: AND i.list_id = podl.list_id
686: AND podl.object_id = p_pcid
687: AND podl.object_type = 'PJP_PLANNING_CYCLE'