APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_ASGMTS_V

Line 7001: SELECT count(*) FROM pa_task_asgmts_v

6997: l_labor_cost_flag VARCHAR2(1) := 'Y';
6998: l_person_id NUMBER; -- Added for Bug 3964394
6999:
7000: CURSOR c_assgmt_count IS
7001: SELECT count(*) FROM pa_task_asgmts_v
7002: WHERE project_id = p_project_id
7003: AND task_id = p_task_id
7004: AND structure_version_id = p_structure_version_id
7005: AND ta_display_flag = 'Y';

Line 7008: SELECT resource_class_code FROM pa_task_asgmts_v

7004: AND structure_version_id = p_structure_version_id
7005: AND ta_display_flag = 'Y';
7006:
7007: CURSOR c_get_task_res_class_code IS
7008: SELECT resource_class_code FROM pa_task_asgmts_v
7009: WHERE project_id = p_project_id
7010: AND task_id = p_task_id
7011: AND structure_version_id = p_structure_version_id
7012: AND ta_display_flag = 'Y';

Line 7015: SELECT resource_class_code, ta_display_flag FROM pa_task_asgmts_v

7011: AND structure_version_id = p_structure_version_id
7012: AND ta_display_flag = 'Y';
7013:
7014: CURSOR c_get_res_class_code IS
7015: SELECT resource_class_code, ta_display_flag FROM pa_task_asgmts_v
7016: WHERE project_id = p_project_id
7017: AND task_id = p_task_id
7018: AND resource_list_member_id = p_object_id
7019: AND structure_version_id = p_structure_version_id;

Line 10538: from pa_task_asgmts_v

10534: IS
10535: /* commented out, performance issue
10536: cursor cur_ptav is
10537: select planned_bur_cost_proj_cur
10538: from pa_task_asgmts_v
10539: where project_id = p_project_id
10540: and task_id = p_task_id
10541: and structure_version_id = p_structure_version_id
10542: and resource_list_member_id = p_resource_list_mem_id;

Line 11731: pa_task_asgmts_v asgn

11727: nvl(asgn.planned_bur_cost_proj_cur-ppr.EQPMT_ACT_COST_TO_DATE_PC,0)))),
11728: nvl(asgn.planned_bur_cost_proj_cur,0)
11729: ))) bac_value_in_task_deriv
11730: FROM
11731: pa_task_asgmts_v asgn
11732: , pa_progress_rollup ppr
11733: WHERE asgn.task_version_id = c_task_ver_id
11734: AND asgn.project_id = p_project_id ---4871809
11735: AND asgn.task_id = p_proj_element_id

Line 11774: pa_task_asgmts_v asgn

11770: , asgn.planned_quantity, 'EQUIPMENT'
11771: , asgn.planned_quantity, 0),0)
11772: ,asgn.planned_bur_cost_proj_cur) bac_value_in_task_deriv
11773: FROM
11774: pa_task_asgmts_v asgn
11775: WHERE asgn.task_version_id = c_task_ver_id
11776: AND asgn.project_id = p_project_id ---4871809
11777: AND asgn.task_id = p_proj_element_id
11778: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id

Line 13368: pa_task_asgmts_v ptav

13364: cursor get_act_eff_to_date is
13365: select decode(ptav.resource_class_code, 'PEOPLE', ppr.PPL_ACT_EFFORT_TO_DATE, 'EQUIPMENT', ppr.EQPMT_ACT_EFFORT_TO_DATE,
13366: ppr.oth_quantity_to_date)
13367: from pa_progress_rollup ppr,
13368: pa_task_asgmts_v ptav
13369: where ptav.project_id = p_project_id
13370: and ptav.task_id = p_proj_element_id
13371: and ptav.project_id = ppr.project_id
13372: and ptav.resource_list_member_id = ppr.object_id