APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_USER

Line 621: l_user fnd_user.user_name%type := null;

617: p_projmg IN VARCHAR2,
618: p_user_exists OUT NOCOPY VARCHAR2 )
619: IS
620:
621: l_user fnd_user.user_name%type := null;
622: l_user_org_id NUMBER;
623: l_user_exists varchar2(1) := 'N';
624:
625: l_pjp_org_version_id NUMBER;

Line 638: fnd_user u ,

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 ,
639: FPA_AW_PC_INFO_V pc
640: WHERE ppp.resource_type_id = 101
641: AND ppp.project_role_id = pprt.project_role_id
642: AND ppp.resource_source_id = pe.person_id

Line 674: fnd_user u,

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
676: WHERE i.recipient_type = 'HZ_PARTY'
677: AND i.list_id = podl.list_id
678: AND podl.object_id = p_pcid

Line 692: fnd_user u

688: select distinct u.user_name
689: from fpa_aw_sce_info_v sc,
690: fpa_aw_proj_info_v proj,
691: pa_project_players pp,
692: fnd_user u
693: where proj.scenario = sc.scenario
694: and sc.planning_cycle = p_pcid
695: and sc.approved_flag = 1
696: and pp.project_id = proj.project