APPS.PA_TASK_MANAGER dependencies on PA_EMPLOYEES_RES_V

Line 983: l_emp_name pa_employees_res_v.employee_name%TYPE;

979: procedure tm_out ( p_project_id IN NUMBER,
980: p_task_manager_person_id IN NUMBER,
981: p_message IN VARCHAR2) IS
982: l_proj_num pa_projects_all.segment1%TYPE;
983: l_emp_name pa_employees_res_v.employee_name%TYPE;
984: len_msg NUMBER;
985: l_count_msg NUMBER;
986: x NUMBER;
987: l_message VARCHAR2(1000);

Line 997: from pa_employees_res_v

993: where project_id = p_project_id;
994:
995: select employee_name
996: into l_emp_name
997: from pa_employees_res_v
998: where person_id = p_task_manager_person_id;
999:
1000: select length(p_message)
1001: into len_msg