DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_ASSIGNMENTS_V

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

5487: IS
5488:
5489: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
5490: SELECT fcst_tp_amount_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;

Line 5501: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;

5497: l_assignment_row_id ROWID;
5498: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
5499:
5500: l_new_assignment_id_tbl system.pa_num_tbl_type;
5501: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;
5502:
5503: BEGIN
5504:
5505: l_status_code := p_status_code ; -- Added default value population for Status Code. Bug 7309934