[Home] [Help]
259: rate_based_flag,
260: resource_class_code,
261: budget_version_id ---4372462
262: FROM
263: pa_task_asgmts_v
264: WHERE
265: project_id = l_project_id
266: AND task_id = l_task_id
267: AND structure_version_id = l_structure_version_id
461: asgn.assignment_start_date scheduled_start_date ,
462: asgn.assignment_end_date scheduled_finish_date,
463: ppc.progress_comment,
464: ppc.description progress_overview
465: from pa_task_asgmts_v asgn
466: , pa_percent_completes ppc
467: , pa_progress_rollup ppr
468: where
469: ppc.PROJECT_ID = l_project_id
5203: , ppr.OTH_ACT_COST_TO_DATE_TC, ppr.OTH_ACT_COST_TO_DATE_PC, ppr.OTH_ACT_COST_TO_DATE_FC
5204: , ppr.OTH_ACT_RAWCOST_TO_DATE_TC, ppr.OTH_ACT_RAWCOST_TO_DATE_PC, ppr.OTH_ACT_RAWCOST_TO_DATE_FC
5205: , ppr.as_of_date
5206: , ptav.assignment_start_date
5207: FROM pa_task_asgmts_V ptav
5208: , pa_progress_rollup ppr
5209: WHERE ptav.task_version_id = c_task_version_id
5210: -- AND ptav.structure_version_id = l_structure_version_id
5211: AND ptav.task_id = c_task_id
5270: , ppr.OTH_ACT_COST_TO_DATE_TC, ppr.OTH_ACT_COST_TO_DATE_PC, ppr.OTH_ACT_COST_TO_DATE_FC
5271: , ppr.OTH_ACT_RAWCOST_TO_DATE_TC, ppr.OTH_ACT_RAWCOST_TO_DATE_PC, ppr.OTH_ACT_RAWCOST_TO_DATE_FC
5272: , ppr.as_of_date
5273: , ptav.assignment_start_date
5274: FROM pa_task_asgmts_V ptav
5275: , pa_progress_rollup ppr
5276: WHERE ptav.task_version_id = c_task_version_id
5277: -- AND ptav.structure_version_id = l_structure_version_id
5278: AND ptav.task_id = c_task_id
6884: -- Bug 3764224 : Changed the cusrosr c4 def'n
6885: cursor c4 (p_project_id NUMBER, p_object_id NUMBER, p_working_str_version_id NUMBER, p_task_id NUMBER) is
6886: select ptav1.resource_assignment_id, ptav1.resource_list_member_id, ptav1.txn_currency_code
6887: ,ptav1.resource_class_code, ptav1.rate_based_flag, ptav1.rbs_element_id
6888: from pa_task_asgmts_v ptav1
6889: where ptav1.resource_list_member_id = p_object_id
6890: and ptav1.structure_version_id = p_working_str_version_id
6891: and ptav1.task_id = p_task_id
6892: ;
6894: cursor c5 (p_project_id NUMBER, p_res_list_member_id NUMBER, p_task_id NUMBER,
6895: p_task_version_id NUMBER, p_structure_version_id NUMBER) is
6896: select rbs_element_id, rate_based_flag, resource_class_code, txn_currency_code
6897: ,resource_list_member_id ,resource_assignment_id--bug 3935699
6898: from pa_task_asgmts_v
6899: where project_id = p_project_id
6900: and resource_list_member_id = p_res_list_member_id -- Commented out to fix Bug # 3815741.
6901: --uncommented the resource_list_member_id for bug 3839699
6902: and task_id = p_task_id
6918: cursor all_lowest_task
6919: is
6920: select task_version_id, 'PA_ASSIGNMENTS' object_type,
6921: resource_assignment_id, TXN_CURRENCY_CODE
6922: from pa_task_asgmts_v ptav
6923: where ptav.project_id= p_project_id
6924: and ptav.structure_version_id = p_working_str_version_id
6925: and ptav.planning_start_date <= l_etc_start_date
6926: -- Bug 3958686 : Commenting the ta_display_flag portion
6957: ,planned_raw_cost_proj_cur
6958: ,planned_raw_cost_projfunc
6959: ,rate_based_flag --bug 3841547
6960: ,ta_display_flag --bug 4021315
6961: from pa_task_asgmts_v
6962: where project_id = p_project_id
6963: -- and resource_assignment_id = p_object_id Bug 3764224
6964: and resource_list_member_id = p_object_id -- Bug 3764224
6965: and task_id = p_task_id
11342: ,planned_raw_cost_proj_cur
11343: ,planned_raw_cost_projfunc
11344: ,rate_based_flag
11345: ,budget_version_id --- 4372462
11346: FROM pa_task_asgmts_v
11347: WHERE project_id = c_project_id
11348: AND resource_list_member_id = c_object_id
11349: AND task_id = c_task_id
11350: AND task_version_id = c_task_version_id
11444: ,planned_raw_cost_proj_cur
11445: ,planned_raw_cost_projfunc
11446: ,rate_based_flag
11447: ,budget_version_id --- 4372462
11448: FROM pa_task_asgmts_v
11449: WHERE project_id = c_project_id
11450: AND task_id = c_task_id
11451: AND task_version_id = c_task_version_id
11452: AND structure_version_id = c_structure_version_id
13702: planned_bur_cost_proj_cur,
13703: planned_raw_cost_txn_cur,
13704: planned_raw_cost_projfunc,
13705: planned_raw_cost_proj_cur
13706: from pa_task_asgmts_v
13707: where project_id = l_project_id
13708: and structure_version_id = l_latest_wp_struct_ver_id
13709: and task_id = l_task_id
13710: and resource_list_member_id = l_res_list_member_id;
19652: l_baseline_version_id NUMBER;
19653:
19654: CURSOR c_get_distinct_str_ver_id IS
19655: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
19656: FROM pa_task_asgmts_v asgn
19657: , pa_proj_elem_ver_structure str
19658: , pa_proj_progress_attr prog
19659: , pa_proj_structure_types pstype
19660: WHERE asgn.person_id = p_person_id
20007: planned_bur_cost_proj_cur,
20008: planned_raw_cost_txn_cur,
20009: planned_raw_cost_projfunc,
20010: planned_raw_cost_proj_cur
20011: from pa_task_asgmts_v ptav2
20012: where ptav2.resource_list_member_id = p_object_id
20013: and ptav2.structure_version_id = p_dst_str_ver_id
20014: and ptav2.task_id = p_task_id
20015: ;
20059: IS
20060: SELECT ptav.*
20061: FROM pa_progress_rollup ppr2
20062: --,pa_task_assignments_v ptav --bug 3967374
20063: ,pa_task_asgmts_v ptav
20064: WHERE ppr2.project_id=p_project_id
20065: AND ptav.project_id=p_project_id
20066: AND ppr2.object_id = ptav.task_id
20067: AND (ptav.resource_list_member_id ) not in (