eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PUB dependencies on PA_TASK_ASGMTS_V

Line 264: pa_task_asgmts_v

260: rate_based_flag,
261: resource_class_code,
262: budget_version_id ---4372462
263: FROM
264: pa_task_asgmts_v
265: WHERE
266: project_id = l_project_id
267: AND task_id = l_task_id
268: AND structure_version_id = l_structure_version_id

Line 466: from pa_task_asgmts_v asgn

462: asgn.assignment_start_date scheduled_start_date ,
463: asgn.assignment_end_date scheduled_finish_date,
464: ppc.progress_comment,
465: ppc.description progress_overview
466: from pa_task_asgmts_v asgn
467: , pa_percent_completes ppc
468: , pa_progress_rollup ppr
469: where
470: ppc.PROJECT_ID = l_project_id

Line 5611: FROM pa_task_asgmts_V ptav

5607: , ppr.OTH_ACT_COST_TO_DATE_TC, ppr.OTH_ACT_COST_TO_DATE_PC, ppr.OTH_ACT_COST_TO_DATE_FC
5608: , ppr.OTH_ACT_RAWCOST_TO_DATE_TC, ppr.OTH_ACT_RAWCOST_TO_DATE_PC, ppr.OTH_ACT_RAWCOST_TO_DATE_FC
5609: , ppr.as_of_date
5610: , ptav.assignment_start_date
5611: FROM pa_task_asgmts_V ptav
5612: , pa_progress_rollup ppr
5613: WHERE ptav.task_version_id = c_task_version_id
5614: -- AND ptav.structure_version_id = l_structure_version_id
5615: AND ptav.task_id = c_task_id

Line 5678: FROM pa_task_asgmts_V ptav

5674: , ppr.OTH_ACT_COST_TO_DATE_TC, ppr.OTH_ACT_COST_TO_DATE_PC, ppr.OTH_ACT_COST_TO_DATE_FC
5675: , ppr.OTH_ACT_RAWCOST_TO_DATE_TC, ppr.OTH_ACT_RAWCOST_TO_DATE_PC, ppr.OTH_ACT_RAWCOST_TO_DATE_FC
5676: , ppr.as_of_date
5677: , ptav.assignment_start_date
5678: FROM pa_task_asgmts_V ptav
5679: , pa_progress_rollup ppr
5680: WHERE ptav.task_version_id = c_task_version_id
5681: -- AND ptav.structure_version_id = l_structure_version_id
5682: AND ptav.task_id = c_task_id

Line 7292: from pa_task_asgmts_v ptav1

7288: -- Bug 3764224 : Changed the cusrosr c4 def'n
7289: cursor c4 (p_project_id NUMBER, p_object_id NUMBER, p_working_str_version_id NUMBER, p_task_id NUMBER, c_cbs_element_id NUMBER) is
7290: select ptav1.resource_assignment_id, ptav1.resource_list_member_id, ptav1.txn_currency_code
7291: ,ptav1.resource_class_code, ptav1.rate_based_flag, ptav1.rbs_element_id
7292: from pa_task_asgmts_v ptav1
7293: where ptav1.resource_list_member_id = p_object_id
7294: AND NVL(ptav1.cbs_element_id,-1)=NVL(c_cbs_element_id,-1)-- NEED TO ADD :::DJ
7295: and ptav1.structure_version_id = p_working_str_version_id
7296: and ptav1.task_id = p_task_id

Line 7303: from pa_task_asgmts_v

7299: cursor c5 (p_project_id NUMBER, p_res_list_member_id NUMBER, p_task_id NUMBER,
7300: p_task_version_id NUMBER, p_structure_version_id NUMBER,c_cbs_element_id NUMBER) is
7301: select rbs_element_id, rate_based_flag, resource_class_code, txn_currency_code
7302: ,resource_list_member_id ,resource_assignment_id--bug 3935699
7303: from pa_task_asgmts_v
7304: where project_id = p_project_id
7305: and resource_list_member_id = p_res_list_member_id -- Commented out to fix Bug # 3815741.
7306: --uncommented the resource_list_member_id for bug 3839699
7307: AND NVL(cbs_element_id,-1)=NVL(c_cbs_element_id,-1)-- for cbs

Line 7328: from pa_task_asgmts_v ptav

7324: cursor all_lowest_task
7325: is
7326: select task_version_id, 'PA_ASSIGNMENTS' object_type,
7327: resource_assignment_id, TXN_CURRENCY_CODE
7328: from pa_task_asgmts_v ptav
7329: where ptav.project_id= p_project_id
7330: and ptav.structure_version_id = p_working_str_version_id
7331: and ptav.planning_start_date <= l_etc_start_date
7332: -- Bug 3958686 : Commenting the ta_display_flag portion

Line 7369: from pa_task_asgmts_v

7365: ,planned_raw_cost_projfunc
7366: ,rate_based_flag --bug 3841547
7367: ,ta_display_flag --bug 4021315
7368: ,CBS_ELEMENT_ID
7369: from pa_task_asgmts_v
7370: where project_id = p_project_id
7371: -- and resource_assignment_id = p_object_id Bug 3764224
7372: and resource_list_member_id = p_object_id -- Bug 3764224 ---:::DJ
7373: and task_id = p_task_id

Line 11795: FROM pa_task_asgmts_v

11791: ,planned_raw_cost_projfunc
11792: ,rate_based_flag
11793: ,budget_version_id --- 4372462
11794: ,cbs_element_id
11795: FROM pa_task_asgmts_v
11796: WHERE project_id = c_project_id
11797: AND resource_list_member_id = c_object_id
11798: AND task_id = c_task_id
11799: AND task_version_id = c_task_version_id

Line 11899: FROM pa_task_asgmts_v

11895: ,planned_raw_cost_projfunc
11896: ,rate_based_flag
11897: ,budget_version_id --- 4372462
11898: ,cbs_element_id
11899: FROM pa_task_asgmts_v
11900: WHERE project_id = c_project_id
11901: AND task_id = c_task_id
11902: AND task_version_id = c_task_version_id
11903: AND structure_version_id = c_structure_version_id

Line 14196: from pa_task_asgmts_v

14192: planned_raw_cost_proj_cur,
14193: --CBS Change in Get_Summarized_Actuals
14194: cbs_element_id
14195: -- End CBS Change in Get_Summarized_Actuals
14196: from pa_task_asgmts_v
14197: where project_id = l_project_id
14198: and structure_version_id = l_latest_wp_struct_ver_id
14199: and task_id = l_task_id
14200: and resource_list_member_id = l_res_list_member_id

Line 21119: FROM pa_task_asgmts_v asgn

21115: l_baseline_version_id NUMBER;
21116:
21117: CURSOR c_get_distinct_str_ver_id IS
21118: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
21119: FROM pa_task_asgmts_v asgn
21120: , pa_proj_elem_ver_structure str
21121: , pa_proj_progress_attr prog
21122: , pa_proj_structure_types pstype
21123: WHERE asgn.person_id = p_person_id

Line 21474: from pa_task_asgmts_v ptav2

21470: planned_bur_cost_proj_cur,
21471: planned_raw_cost_txn_cur,
21472: planned_raw_cost_projfunc,
21473: planned_raw_cost_proj_cur
21474: from pa_task_asgmts_v ptav2
21475: where ptav2.resource_list_member_id = p_object_id
21476: and ptav2.structure_version_id = p_dst_str_ver_id
21477: and ptav2.task_id = p_task_id
21478: ;

Line 21526: ,pa_task_asgmts_v ptav

21522: IS
21523: SELECT ptav.*
21524: FROM pa_progress_rollup ppr2
21525: --,pa_task_assignments_v ptav --bug 3967374
21526: ,pa_task_asgmts_v ptav
21527: WHERE ppr2.project_id=p_project_id
21528: AND ptav.project_id=p_project_id
21529: AND ppr2.object_id = ptav.task_id
21530: AND (ptav.resource_list_member_id ) not in (