APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_TASK_ASSIGNMENTS_V

Line 356: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;

352: --bug 3608801
353: -- Bug 3606627 Start
354: l_resource_list_member_id NUMBER;
355: l_rate_based_flag VARCHAR2(1);
356: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
357: l_rbs_element_id NUMBER;
358: l_actual_raw_cost NUMBER;
359: l_actual_raw_cost_this_period NUMBER;
360: l_actual_bur_cost NUMBER;

Line 456: FROM pa_task_assignments_v

452: /*
453: --bug 3958686, check whether the the assignment is hidden assignment, start
454: CURSOR cur_assgmt(l_resource_list_member_id NUMBER, l_resource_assignment_id NUMBER, l_task_id NUMBER, l_project_id NUMBER, l_structure_version_id NUMBER) IS
455: SELECT ta_display_flag
456: FROM pa_task_assignments_v
457: WHERE RESOURCE_LIST_MEMBER_ID = l_resource_list_member_id AND
458: RESOURCE_ASSIGNMENT_ID = l_resource_assignment_id AND
459: TASK_ID = l_task_id AND
460: PROJECT_ID = l_project_id AND

Line 1106: FROM pa_task_assignments_v

1102: SELECT rate_based_flag, resource_class_code, txn_currency_code,
1103: rbs_element_id, resource_list_member_id, assignment_start_date, assignment_end_date -- Bug 3956299 : Added assignment_end_date
1104: INTO l_rate_based_flag, l_resource_class_code, l_txn_currency_code,
1105: l_rbs_element_id, l_resource_list_member_id, l_scheduled_start_date, l_scheduled_finish_date -- Bug 3956299 : Added l_scheduled_finish_date
1106: FROM pa_task_assignments_v
1107: WHERE --resource_assignment_id = l_assignment_id Bug 3799841
1108: resource_list_member_id = l_resource_list_member_id -- Bug 3799841
1109: AND structure_version_id = p_structure_version_id
1110: AND task_version_id = l_object_version_id;