APPS.PA_UTILS3 dependencies on PA_TASKS

Line 146: Pa_Tasks

142: Task_Number
143: Into
144: X_Task_Number
145: From
146: Pa_Tasks
147: Where
148: Task_Id = P_Task_Id;
149:
150: -- Add the task number to the pl/sql table using the task_id

Line 406: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE

402: return l_Project_Number;
403:
404: End GetCachedProjNum;
405:
406: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE
407: Is
408: l_Task_Number pa_tasks.task_number%TYPE;
409: Begin
410:

Line 408: l_Task_Number pa_tasks.task_number%TYPE;

404: End GetCachedProjNum;
405:
406: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE
407: Is
408: l_Task_Number pa_tasks.task_number%TYPE;
409: Begin
410:
411: If P_Task_Id > 0 THEN
412: GetCachedTaskNum(P_Task_Id => P_Task_Id,

Line 459: ,pa_tasks task

455: SELECT proj.segment1||'/'||TASK.task_number
456: INTO l_proj_task_info
457: FROM pa_expenditure_items ei
458: ,pa_projects_all proj
459: ,pa_tasks task
460: WHERE ei.expenditure_item_id = P_Transferred_from_exp_id
461: AND ei.task_id = task.task_id
462: AND proj.project_id = task.project_id;
463: EXCEPTION

Line 474: ,pa_tasks task

470: SELECT proj.segment1||'/'||TASK.task_number
471: INTO l_proj_task_info
472: FROM pa_expenditure_items ei
473: ,pa_projects_all proj
474: ,pa_tasks task
475: WHERE ei.transferred_from_exp_item_id = P_exp_item_id
476: AND ei.task_id = task.task_id
477: AND proj.project_id = task.project_id;
478: EXCEPTION