APPS.PA_ASSIGNMENTS_PUB dependencies on PA_RESOURCES_DENORM

Line 6111: l_resource_id pa_resources_denorm.resource_id%TYPE;

6107: l_msg_data VARCHAR2(2000);
6108: l_msg_count NUMBER;
6109: l_msg_index_out NUMBER;
6110: l_assignment_rec assignment_rec_type;
6111: l_resource_id pa_resources_denorm.resource_id%TYPE;
6112: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
6113: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
6114:
6115: BEGIN

Line 6471: l_resource_id pa_resources_denorm.resource_id%TYPE;

6467: FROM pa_project_assignments -- 5078700 changed from pa_project_assignments_v to pa_project_assignments
6468: WHERE assignment_id = p_asg_id;
6469:
6470: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
6471: l_resource_id pa_resources_denorm.resource_id%TYPE;
6472: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6473: l_assignment_row_id ROWID;
6474: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
6475:

Line 6762: l_resource_id pa_resources_denorm.resource_id%TYPE;

6758: IS
6759:
6760: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
6761: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
6762: l_resource_id pa_resources_denorm.resource_id%TYPE;
6763: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6764: l_assignment_row_id ROWID;
6765: l_new_assignment_tabl system.pa_num_tbl_type;
6766: l_return_status VARCHAR2(1);