APPS.JTF_EC_WORKFLOW_PKG dependencies on PER_ALL_PEOPLE_F

Line 162: l_owner_name per_all_people_f.full_name%TYPE := NULL;

158: c cur_typ;
159:
160: l_api_name VARCHAR2(30) := 'Get_Doc_Owner_Name';
161:
162: l_owner_name per_all_people_f.full_name%TYPE := NULL;
163: l_owner_id NUMBER := NULL;
164: l_resource_type jtf_objects_vl.object_code%TYPE := NULL;
165: l_resource_type_dev jtf_objects_vl.object_code%TYPE := NULL;
166: l_phase_owner_name VARCHAR2(240);

Line 667: l_person_name per_all_people_f.full_name%TYPE;

663: l_object_desc varchar2(1000);
664: l_doc_details_t varchar2(4000);
665: l_doc_details_h varchar2(4000);
666: l_resource_id NUMBER :=NULL;
667: l_person_name per_all_people_f.full_name%TYPE;
668: l_temp_status VARCHAR2(2);
669:
670: cursor get_doc_details is
671: SELECT jo.name object_type,

Line 744: l_name per_all_people_f.full_name%TYPE := NULL; --Bug 2700953

740: x_row_number OUT NOCOPY NUMBER,
741: x_return_status OUT NOCOPY VARCHAR2) Is
742:
743: l_api_name VARCHAR2(30) := 'SetNotifList';
744: l_name per_all_people_f.full_name%TYPE := NULL; --Bug 2700953
745: l_role_name wf_users.name%TYPE := NULL;
746: l_display_name wf_users.display_name%TYPE := NULL;
747: l_manager_id per_all_people_f.person_id%TYPE := NULL;
748: l_temp_status VARCHAR2(2);

Line 747: l_manager_id per_all_people_f.person_id%TYPE := NULL;

743: l_api_name VARCHAR2(30) := 'SetNotifList';
744: l_name per_all_people_f.full_name%TYPE := NULL; --Bug 2700953
745: l_role_name wf_users.name%TYPE := NULL;
746: l_display_name wf_users.display_name%TYPE := NULL;
747: l_manager_id per_all_people_f.person_id%TYPE := NULL;
748: l_temp_status VARCHAR2(2);
749: l_new_line VARCHAR2(4) := '
750: ';
751:

Line 767: FROM per_all_people_F

763: -- Employee contact name
764: -------------------------------------------------------------------------
765: cursor get_employee_name(p_emp_id NUMBER) is
766: SELECT full_name
767: FROM per_all_people_F
768: WHERE person_id = p_emp_id;
769: --FROM per_employees_current_x
770: --WHERE employee_id = p_emp_id;
771: