APPS.PA_ASGMT_WFSTD dependencies on PER_PEOPLE_F

Line 143: FROM per_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_people_f per,
144: per_assignments_f assign,
145: hr_all_organization_units hou,
146: pa_resource_txn_attributes rta
147: WHERE rta.resource_id = l_resource_id

Line 206: l_wf_started_by_full_name per_people_f.full_name%TYPE;

202: l_responsibility_id NUMBER;
203: l_resp_appl_id NUMBER;
204: l_wf_started_date DATE;
205: l_wf_started_by_id NUMBER;
206: l_wf_started_by_full_name per_people_f.full_name%TYPE;
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 ;

Line 207: l_wf_started_by_email_address per_people_f.email_address%TYPE;

203: l_resp_appl_id NUMBER;
204: l_wf_started_date DATE;
205: l_wf_started_by_id NUMBER;
206: l_wf_started_by_full_name per_people_f.full_name%TYPE;
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

Line 303: l_res_manager_id PER_PEOPLE_F.PERSON_ID%TYPE; -- Added for bug 4334741

299: l_save_threshold NUMBER;
300: l_override_basis_name VARCHAR2(80) := NULL;
301:
302: l_last_approver_uname fnd_user.USER_NAME%TYPE; --- VARCHAR2(240); -- Added for the bug 3817940
303: l_res_manager_id PER_PEOPLE_F.PERSON_ID%TYPE; -- Added for bug 4334741
304: BEGIN
305: -- dbms_output.put_line ('inside start workflow');
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307: /*

Line 4877: FROM per_people_f per,

4873:
4874: CURSOR l_resource_csr(l_resource_id IN NUMBER, p_start_date IN DATE) IS
4875: SELECT per.full_name resource_name,
4876: hou.name
4877: FROM per_people_f per,
4878: per_assignments_f assign,
4879: hr_all_organization_units hou,
4880: pa_resource_txn_attributes rta
4881: WHERE rta.resource_id = l_resource_id