DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_ASSIGNMENT_PROGRESS_V

Line 122: FROM pa_assignment_progress_v prog

118: p_resource_assignment_id,
119: 'PA_ASSIGNMENTS',
120: 'WORKPLAN'
121: ) Progress_Exists
122: FROM pa_assignment_progress_v prog
123: WHERE prog.resource_assignment_id = p_resource_assignment_id;
124:
125: l_prog_finish_date DATE;
126: l_progress_exists varchar2(1);

Line 149: SELECT a.as_of_date from pa_assignment_progress_v a

145:
146: -- Bug# 6432606 Start
147: /*
148: CURSOR C_Prog_Date(p_resource_assignment_id IN NUMBER) IS
149: SELECT a.as_of_date from pa_assignment_progress_v a
150: WHERE a.resource_assignment_id = p_resource_assignment_id
151: and a.project_id = p_pa_project_id
152: and a.structure_version_id = p_pa_structure_version_id;
153: */