DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_TASK_ASSIGNMENTS_V

Line 173: FROM pa_task_assignments_v

169:
170: -- Bug 3799841 Begin
171: CURSOR c_get_rlm_id(c_project_id NUMBER, c_object_id NUMBER, c_structure_version_id NUMBER, c_task_version_id NUMBER) IS
172: SELECT resource_list_member_id
173: FROM pa_task_assignments_v
174: WHERE project_id = c_project_id
175: AND resource_assignment_id = c_object_id
176: AND structure_version_id = c_structure_version_id
177: AND task_version_id = c_task_version_id;

Line 181: FROM pa_task_assignments_v

177: AND task_version_id = c_task_version_id;
178:
179: CURSOR c_verify_rlm_id(c_project_id NUMBER, c_object_id NUMBER, c_structure_version_id NUMBER, c_task_version_id NUMBER) IS
180: SELECT 'Y', ta_display_flag
181: FROM pa_task_assignments_v
182: WHERE project_id = c_project_id
183: AND resource_list_member_id = c_object_id
184: AND structure_version_id = c_structure_version_id
185: AND task_version_id = c_task_version_id;