APPS.PA_WORK_TYPE_UTILS dependencies on PA_PROJECTS

Line 90: ,p_project_id IN pa_projects.project_id%TYPE

86: -- ----------------------------------------------------------------------------
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

Line 98: l_project_id pa_projects.project_id%TYPE;

94: IS
95: BEGIN
96: DECLARE
97: l_proj_typ_class_code pa_project_types.project_type_class_code%TYPE;
98: l_project_id pa_projects.project_id%TYPE;
99: l_project_type pa_project_types.project_type%TYPE;
100: l_flag varchar2(1);
101: CURSOR Get_Project_type_class_cur IS
102: SELECT p.project_type_class_code

Line 107: FROM pa_projects a

103: FROM pa_project_types p
104: WHERE p.project_type = l_project_type;
105: CURSOR Get_Project_type IS
106: SELECT a.project_type
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