APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_TASK_ASSIGNMENTS_V

Line 351: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;

347: --bug 3608801
348: -- Bug 3606627 Start
349: l_resource_list_member_id NUMBER;
350: l_rate_based_flag VARCHAR2(1);
351: l_resource_class_code pa_task_assignments_v.resource_class_code%TYPE;
352: l_rbs_element_id NUMBER;
353: l_actual_raw_cost NUMBER;
354: l_actual_raw_cost_this_period NUMBER;
355: l_actual_bur_cost NUMBER;

Line 450: FROM pa_task_assignments_v

446: /*
447: --bug 3958686, check whether the the assignment is hidden assignment, start
448: 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
449: SELECT ta_display_flag
450: FROM pa_task_assignments_v
451: WHERE RESOURCE_LIST_MEMBER_ID = l_resource_list_member_id AND
452: RESOURCE_ASSIGNMENT_ID = l_resource_assignment_id AND
453: TASK_ID = l_task_id AND
454: PROJECT_ID = l_project_id AND

Line 1027: FROM pa_task_assignments_v

1023: SELECT rate_based_flag, resource_class_code, txn_currency_code,
1024: rbs_element_id, resource_list_member_id, assignment_start_date, assignment_end_date -- Bug 3956299 : Added assignment_end_date
1025: INTO l_rate_based_flag, l_resource_class_code, l_txn_currency_code,
1026: l_rbs_element_id, l_resource_list_member_id, l_scheduled_start_date, l_scheduled_finish_date -- Bug 3956299 : Added l_scheduled_finish_date
1027: FROM pa_task_assignments_v
1028: WHERE --resource_assignment_id = l_assignment_id Bug 3799841
1029: resource_list_member_id = l_resource_list_member_id -- Bug 3799841
1030: AND structure_version_id = p_structure_version_id
1031: AND task_version_id = l_object_version_id;