APPS.FPA_MAIN_PROCESS_PVT dependencies on FND_USER

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

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

Line 642: fnd_user u ,

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
646: AND ppp.resource_source_id = pe.person_id

Line 667: fnd_user u

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
671: AND podl.object_type = 'PJP_PLANNING_CYCLE'

Line 682: fnd_user u,

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

Line 701: fnd_user u

697: select distinct u.user_name
698: from fpa_aw_sce_info_v sc,
699: fpa_aw_proj_info_v proj,
700: pa_project_players pp,
701: fnd_user u
702: where proj.scenario = sc.scenario
703: and sc.planning_cycle = p_pcid
704: and sc.approved_flag = 1
705: and pp.project_id = proj.project