eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASGMT_WFSTD dependencies on PER_ALL_PEOPLE_F

Line 143: FROM per_all_people_f per,

139: rta.person_id resource_person_id,
140: rta.resource_id resource_id,
141: hou.name resource_organization_name,
142: assign.supervisor_id manager_id
143: FROM per_all_people_f per,
144: per_all_assignments_f assign,
145: hr_all_organization_units hou,
146: pa_resource_txn_attributes rta
147: WHERE rta.resource_id = l_resource_id

Line 211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

207: l_wf_started_by_email_address per_people_f.email_address%TYPE;
208: l_wf_started_by_username fnd_user.user_name%TYPE;
209: l_display_name wf_users.display_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
210: l_project_manager_person_id NUMBER ;
211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
213: l_project_party_id NUMBER ;
214: l_project_role_id NUMBER ;
215: l_project_role_name pa_project_role_types.meaning%TYPE; ---- VARCHAR2(80); Changed for bug 3267790

Line 3920: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790

3916: , p_approver2_person_id IN NUMBER
3917: , p_approver2_type IN VARCHAR2
3918: , x_PrimaryContactId OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3919: IS
3920: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790
3921: l_managerid NUMBER := 0;
3922: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790
3923: l_return_status VARCHAR2(1);
3924: l_msg_count NUMBER ;

Line 3922: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790

3918: , x_PrimaryContactId OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3919: IS
3920: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790
3921: l_managerid NUMBER := 0;
3922: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790
3923: l_return_status VARCHAR2(1);
3924: l_msg_count NUMBER ;
3925: l_msg_data VARCHAR2(2000);
3926: BEGIN

Line 5928: l_project_manager_name per_all_people_f.full_name%TYPE; --VARCHAR2(200); Changed for bug 3267790

5924:
5925: l_res_mgr_person_id NUMBER;
5926: l_staff_mgr_person_id NUMBER;
5927: l_project_manager_person_id NUMBER ;
5928: l_project_manager_name per_all_people_f.full_name%TYPE; --VARCHAR2(200); Changed for bug 3267790
5929: l_project_party_id NUMBER ;
5930: l_project_role_id NUMBER ;
5931: l_project_role_name VARCHAR2(80);
5932: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not

Line 5967: per_all_people_f per

5963: from dual) temp, */
5964: pa_project_assignments asgn,
5965: pa_wf_ntf_performers ntf,
5966: wf_roles wf,
5967: per_all_people_f per
5968: WHERE ntf.group_id = p_group_id
5969: AND asgn.assignment_id = l_assignment_id
5970: AND asgn.assignment_id = ntf.object_id1
5971: AND res.resource_id = asgn.resource_id

Line 6950: l_project_manager_name per_all_people_f.full_name%TYPE;--VARCHAR2(200); Commented For 3267790

6946:
6947: l_customer_id NUMBER;
6948: l_customer_name VARCHAR2(2000);
6949: l_project_manager_person_id NUMBER ;
6950: l_project_manager_name per_all_people_f.full_name%TYPE;--VARCHAR2(200); Commented For 3267790
6951: l_project_party_id NUMBER ;
6952: l_project_role_id NUMBER ;
6953: l_project_role_name VARCHAR2(80);
6954: