3544: BEGIN
3545:
3546: SELECT pat.task_name
3547: INTO l_emp_tr_data
3548: FROM PA_TASKS pat
3549: WHERE pat.task_id = p_taskId;
3550:
3551: RETURN l_emp_tr_data;
3552:
5842: FUNCTION Get_Ap_Task_Name (p_task_id IN NUMBER)
5843:
5844: RETURN VARCHAR2 IS
5845:
5846: l_task_name pa_tasks_expend_v.task_name%type;
5847:
5848: BEGIN
5849:
5850: SELECT task_name
5848: BEGIN
5849:
5850: SELECT task_name
5851: INTO l_task_name
5852: FROM pa_tasks_expend_v
5853: WHERE task_id = p_task_id;
5854:
5855: RETURN(l_task_name);
5856: