APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_ASGMTS_V

Line 6961: SELECT count(*) FROM pa_task_asgmts_v

6957: l_labor_cost_flag VARCHAR2(1) := 'Y';
6958: l_person_id NUMBER; -- Added for Bug 3964394
6959:
6960: CURSOR c_assgmt_count IS
6961: SELECT count(*) FROM pa_task_asgmts_v
6962: WHERE project_id = p_project_id
6963: AND task_id = p_task_id
6964: AND structure_version_id = p_structure_version_id
6965: AND ta_display_flag = 'Y';

Line 6968: SELECT resource_class_code FROM pa_task_asgmts_v

6964: AND structure_version_id = p_structure_version_id
6965: AND ta_display_flag = 'Y';
6966:
6967: CURSOR c_get_task_res_class_code IS
6968: SELECT resource_class_code FROM pa_task_asgmts_v
6969: WHERE project_id = p_project_id
6970: AND task_id = p_task_id
6971: AND structure_version_id = p_structure_version_id
6972: AND ta_display_flag = 'Y';

Line 6975: SELECT resource_class_code, ta_display_flag FROM pa_task_asgmts_v

6971: AND structure_version_id = p_structure_version_id
6972: AND ta_display_flag = 'Y';
6973:
6974: CURSOR c_get_res_class_code IS
6975: SELECT resource_class_code, ta_display_flag FROM pa_task_asgmts_v
6976: WHERE project_id = p_project_id
6977: AND task_id = p_task_id
6978: AND resource_list_member_id = p_object_id
6979: AND structure_version_id = p_structure_version_id;

Line 10463: from pa_task_asgmts_v

10459: IS
10460: /* commented out, performance issue
10461: cursor cur_ptav is
10462: select planned_bur_cost_proj_cur
10463: from pa_task_asgmts_v
10464: where project_id = p_project_id
10465: and task_id = p_task_id
10466: and structure_version_id = p_structure_version_id
10467: and resource_list_member_id = p_resource_list_mem_id;

Line 11651: pa_task_asgmts_v asgn

11647: nvl(asgn.planned_bur_cost_proj_cur-ppr.EQPMT_ACT_COST_TO_DATE_PC,0)))),
11648: nvl(asgn.planned_bur_cost_proj_cur,0)
11649: ))) bac_value_in_task_deriv
11650: FROM
11651: pa_task_asgmts_v asgn
11652: , pa_progress_rollup ppr
11653: WHERE asgn.task_version_id = c_task_ver_id
11654: AND asgn.project_id = p_project_id ---4871809
11655: AND asgn.task_id = p_proj_element_id

Line 11694: pa_task_asgmts_v asgn

11690: , asgn.planned_quantity, 'EQUIPMENT'
11691: , asgn.planned_quantity, 0),0)
11692: ,asgn.planned_bur_cost_proj_cur) bac_value_in_task_deriv
11693: FROM
11694: pa_task_asgmts_v asgn
11695: WHERE asgn.task_version_id = c_task_ver_id
11696: AND asgn.project_id = p_project_id ---4871809
11697: AND asgn.task_id = p_proj_element_id
11698: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id