DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_ASSIGNMENT_PROGRESS_V

Line 108: FROM pa_assignment_progress_v prog

104: p_resource_assignment_id,
105: 'PA_ASSIGNMENTS',
106: 'WORKPLAN'
107: ) Progress_Exists
108: FROM pa_assignment_progress_v prog
109: WHERE prog.resource_assignment_id = p_resource_assignment_id;
110:
111: l_prog_finish_date DATE;
112: l_progress_exists varchar2(1);

Line 135: SELECT a.as_of_date from pa_assignment_progress_v a

131:
132: -- Bug# 6432606 Start
133: /*
134: CURSOR C_Prog_Date(p_resource_assignment_id IN NUMBER) IS
135: SELECT a.as_of_date from pa_assignment_progress_v a
136: WHERE a.resource_assignment_id = p_resource_assignment_id
137: and a.project_id = p_pa_project_id
138: and a.structure_version_id = p_pa_structure_version_id;
139: */