APPS.PA_ASSIGNMENTS_PUB dependencies on PA_RESOURCES_DENORM

Line 5135: l_resource_id pa_resources_denorm.resource_id%TYPE;

5131: l_msg_data VARCHAR2(2000);
5132: l_msg_count NUMBER;
5133: l_msg_index_out NUMBER;
5134: l_assignment_rec assignment_rec_type;
5135: l_resource_id pa_resources_denorm.resource_id%TYPE;
5136: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
5137: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
5138:
5139: BEGIN

Line 5495: l_resource_id pa_resources_denorm.resource_id%TYPE;

5491: FROM pa_project_assignments -- 5078700 changed from pa_project_assignments_v to pa_project_assignments
5492: WHERE assignment_id = p_asg_id;
5493:
5494: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
5495: l_resource_id pa_resources_denorm.resource_id%TYPE;
5496: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5497: l_assignment_row_id ROWID;
5498: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
5499:

Line 5786: l_resource_id pa_resources_denorm.resource_id%TYPE;

5782: IS
5783:
5784: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
5785: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
5786: l_resource_id pa_resources_denorm.resource_id%TYPE;
5787: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5788: l_assignment_row_id ROWID;
5789: l_new_assignment_tabl system.pa_num_tbl_type;
5790: l_return_status VARCHAR2(1);