APPS.PA_WORK_TYPE_UTILS dependencies on PA_TASKS

Line 91: ,p_task_id IN pa_tasks.task_id%TYPE

87: --
88: procedure Check_Work_Type
89: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
90: ,p_project_id IN pa_projects.project_id%TYPE
91: ,p_task_id IN pa_tasks.task_id%TYPE
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_error_message_code OUT NOCOPY VARCHAR2)
94: IS
95: BEGIN

Line 111: FROM pa_tasks t

107: FROM pa_projects a
108: WHERE a.project_id = l_project_id;
109: CURSOR Get_Project_id IS
110: SELECT t.project_id
111: FROM pa_tasks t
112: WHERE t.task_id = p_task_id;
113: CURSOR work_type_cur IS
114: SELECT w.BILLABLE_CAPITALIZABLE_FLAG
115: FROM pa_work_types_b w -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829