3386: BEGIN
3387:
3388: SELECT pat.task_name
3389: INTO l_emp_tr_data
3390: FROM PA_TASKS pat
3391: WHERE pat.task_id = p_taskId;
3392:
3393: RETURN l_emp_tr_data;
3394:
5684: FUNCTION Get_Ap_Task_Name (p_task_id IN NUMBER)
5685:
5686: RETURN VARCHAR2 IS
5687:
5688: l_task_name pa_tasks_expend_v.task_name%type;
5689:
5690: BEGIN
5691:
5692: SELECT task_name
5690: BEGIN
5691:
5692: SELECT task_name
5693: INTO l_task_name
5694: FROM pa_tasks_expend_v
5695: WHERE task_id = p_task_id;
5696:
5697: RETURN(l_task_name);
5698: