DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on PA_TASKS_EXPEND_V

Line 2004: from pa_tasks_expend_v

2000:
2001: function GET_PATEO_TASK_NAME(p_task_id in number,
2002: p_project_id in number) return varchar2 is
2003: cursor c1 is select task_name
2004: from pa_tasks_expend_v
2005: where task_id = p_task_id
2006: and Project_id = p_project_id;
2007: l_name pa_tasks_expend_v.task_name%type;
2008: begin

Line 2007: l_name pa_tasks_expend_v.task_name%type;

2003: cursor c1 is select task_name
2004: from pa_tasks_expend_v
2005: where task_id = p_task_id
2006: and Project_id = p_project_id;
2007: l_name pa_tasks_expend_v.task_name%type;
2008: begin
2009: if p_project_id is not null and p_task_id is not null then
2010: open c1;
2011: fetch c1 into l_name;