DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 4234: FROM pa_project_assignments_v

4230: ,max_resource_job_level
4231: INTO l_fcst_tp_amount_type
4232: ,l_min_resource_job_level
4233: ,l_max_resource_job_level
4234: FROM pa_project_assignments_v
4235:
4236: WHERE assignment_id= l_assignment_id;
4237: end if;
4238: -- Bug#9468685

Line 6467: FROM pa_project_assignments -- 5078700 changed from pa_project_assignments_v to pa_project_assignments

6463: IS
6464:
6465: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
6466: SELECT fcst_tp_amount_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;

Line 6477: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;

6473: l_assignment_row_id ROWID;
6474: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
6475:
6476: l_new_assignment_id_tbl system.pa_num_tbl_type;
6477: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;
6478:
6479: BEGIN
6480:
6481: l_status_code := p_status_code ; -- Added default value population for Status Code. Bug 7309934