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_COST_PLUS dependencies on PA_COST_BASE_EXP_TYPES

Line 3504: pa_cost_base_exp_types cbet

3500: SELECT
3501: cbet.cost_base
3502: INTO c_base
3503: FROM
3504: pa_cost_base_exp_types cbet
3505: WHERE
3506: cbet.cost_plus_structure = cp_structure
3507: AND cbet.expenditure_type = exp_type
3508: AND cbet.cost_base_type = INDIRECT_COST_CODE;

Line 3956: FROM pa_cost_base_exp_types

3952: IS
3953: SELECT cost_base,
3954: cost_base_type,
3955: expenditure_type
3956: FROM pa_cost_base_exp_types
3957: WHERE cost_plus_structure = source;
3958:
3959: -- Local variables
3960: cbicc_id number;

Line 4030: INSERT INTO pa_cost_base_exp_types

4026: stage := 200;
4027:
4028: for et_row in et_cursor loop
4029:
4030: INSERT INTO pa_cost_base_exp_types
4031: (cost_plus_structure,
4032: cost_base,
4033: cost_base_type,
4034: expenditure_type,

Line 4346: from pa_cost_base_exp_types cbet

4342: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4343: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4344: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4345: AND exists (select /*+ PUSH_SUBQ NO_UNNEST */ null
4346: from pa_cost_base_exp_types cbet
4347: --where cbet.cost_base = cost_base_rec.cost_base
4348: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4349: AND cbet.cost_plus_structure = G_CP_STRUCTURE
4350: AND cbet.cost_base_type = INDIRECT_COST_CODE

Line 4560: from pa_cost_base_exp_types cbet

4556: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4557: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4558: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4559: AND exists (select /*+ NO_UNNEST */ null
4560: from pa_cost_base_exp_types cbet
4561: -- where cbet.cost_base = cost_base_rec.cost_base -- 4527736
4562: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4563: AND cbet.cost_plus_structure = l_cp_structure
4564: AND cbet.cost_base_type = INDIRECT_COST_CODE

Line 4650: from pa_cost_base_exp_types cbet

4646: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4647: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4648: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y' /* missing condition added for bug 4574721 */
4649: AND EXISTS (select /*+ NO_UNNEST */ 1
4650: from pa_cost_base_exp_types cbet
4651: --where cbet.cost_base = cost_base_rec.cost_base
4652: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4653: and cbet.cost_plus_structure = l_cp_structure
4654: and cbet.cost_base_type = INDIRECT_COST_CODE

Line 6632: FROM pa_cost_base_exp_types cbet

6628: WHERE cost_ind_compiled_set_id = compiled_set_id
6629: AND adjustment_type in ('BURDEN_RECOMPILE','BURDEN_RESUMMARIZE','RECALC_BURDEN')
6630: AND request_id = x_request_id
6631: AND EXISTS (SELECT NULL
6632: FROM pa_cost_base_exp_types cbet
6633: WHERE cbet.cost_base = p_cost_base
6634: AND cbet.cost_plus_structure = p_cost_plus_structure
6635: AND cbet.cost_base_type = INDIRECT_COST_CODE
6636: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6647: FROM pa_cost_base_exp_types cbet

6643: FROM pa_expenditure_items_all ITEM
6644: WHERE rev_ind_compiled_set_id = compiled_set_id
6645: AND request_id = x_request_id
6646: AND EXISTS (SELECT NULL
6647: FROM pa_cost_base_exp_types cbet
6648: WHERE cbet.cost_base = p_cost_base
6649: AND cbet.cost_plus_structure = p_cost_plus_structure
6650: AND cbet.cost_base_type = INDIRECT_COST_CODE
6651: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6662: FROM pa_cost_base_exp_types cbet

6658: FROM pa_expenditure_items_all ITEM
6659: WHERE inv_ind_compiled_set_id = compiled_set_id
6660: AND request_id = x_request_id
6661: AND EXISTS (SELECT NULL
6662: FROM pa_cost_base_exp_types cbet
6663: WHERE cbet.cost_base = p_cost_base
6664: AND cbet.cost_plus_structure = p_cost_plus_structure
6665: AND cbet.cost_base_type = INDIRECT_COST_CODE
6666: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6681: FROM pa_cost_base_exp_types cbet

6677: FROM pa_expenditure_items_all ITEM
6678: WHERE tp_ind_compiled_set_id = compiled_set_id
6679: AND request_id = x_request_id
6680: AND EXISTS (SELECT NULL
6681: FROM pa_cost_base_exp_types cbet
6682: WHERE cbet.cost_base = p_cost_base
6683: AND cbet.cost_plus_structure = p_cost_plus_structure
6684: AND cbet.cost_base_type = INDIRECT_COST_CODE
6685: AND cbet.expenditure_type = ITEM.expenditure_type