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 3474: pa_cost_base_exp_types cbet

3470: SELECT
3471: cbet.cost_base
3472: INTO c_base
3473: FROM
3474: pa_cost_base_exp_types cbet
3475: WHERE
3476: cbet.cost_plus_structure = cp_structure
3477: AND cbet.expenditure_type = exp_type
3478: AND cbet.cost_base_type = INDIRECT_COST_CODE;

Line 3926: FROM pa_cost_base_exp_types

3922: IS
3923: SELECT cost_base,
3924: cost_base_type,
3925: expenditure_type
3926: FROM pa_cost_base_exp_types
3927: WHERE cost_plus_structure = source;
3928:
3929: -- Local variables
3930: cbicc_id number;

Line 4000: INSERT INTO pa_cost_base_exp_types

3996: stage := 200;
3997:
3998: for et_row in et_cursor loop
3999:
4000: INSERT INTO pa_cost_base_exp_types
4001: (cost_plus_structure,
4002: cost_base,
4003: cost_base_type,
4004: expenditure_type,

Line 4316: from pa_cost_base_exp_types cbet

4312: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4313: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4314: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4315: AND exists (select /*+ NO_UNNEST */ null
4316: from pa_cost_base_exp_types cbet
4317: --where cbet.cost_base = cost_base_rec.cost_base
4318: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4319: AND cbet.cost_plus_structure = G_CP_STRUCTURE
4320: AND cbet.cost_base_type = INDIRECT_COST_CODE

Line 4530: from pa_cost_base_exp_types cbet

4526: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4527: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4528: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4529: AND exists (select /*+ NO_UNNEST */ null
4530: from pa_cost_base_exp_types cbet
4531: -- where cbet.cost_base = cost_base_rec.cost_base -- 4527736
4532: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4533: AND cbet.cost_plus_structure = l_cp_structure
4534: AND cbet.cost_base_type = INDIRECT_COST_CODE

Line 4620: from pa_cost_base_exp_types cbet

4616: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4617: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4618: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y' /* missing condition added for bug 4574721 */
4619: AND EXISTS (select /*+ NO_UNNEST */ 1
4620: from pa_cost_base_exp_types cbet
4621: --where cbet.cost_base = cost_base_rec.cost_base
4622: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4623: and cbet.cost_plus_structure = l_cp_structure
4624: and cbet.cost_base_type = INDIRECT_COST_CODE

Line 6405: FROM pa_cost_base_exp_types cbet

6401: WHERE cost_ind_compiled_set_id = compiled_set_id
6402: AND adjustment_type in ('BURDEN_RECOMPILE','BURDEN_RESUMMARIZE','RECALC_BURDEN')
6403: AND request_id = x_request_id
6404: AND EXISTS (SELECT NULL
6405: FROM pa_cost_base_exp_types cbet
6406: WHERE cbet.cost_base = p_cost_base
6407: AND cbet.cost_plus_structure = p_cost_plus_structure
6408: AND cbet.cost_base_type = INDIRECT_COST_CODE
6409: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6420: FROM pa_cost_base_exp_types cbet

6416: FROM pa_expenditure_items_all ITEM
6417: WHERE rev_ind_compiled_set_id = compiled_set_id
6418: AND request_id = x_request_id
6419: AND EXISTS (SELECT NULL
6420: FROM pa_cost_base_exp_types cbet
6421: WHERE cbet.cost_base = p_cost_base
6422: AND cbet.cost_plus_structure = p_cost_plus_structure
6423: AND cbet.cost_base_type = INDIRECT_COST_CODE
6424: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6435: FROM pa_cost_base_exp_types cbet

6431: FROM pa_expenditure_items_all ITEM
6432: WHERE inv_ind_compiled_set_id = compiled_set_id
6433: AND request_id = x_request_id
6434: AND EXISTS (SELECT NULL
6435: FROM pa_cost_base_exp_types cbet
6436: WHERE cbet.cost_base = p_cost_base
6437: AND cbet.cost_plus_structure = p_cost_plus_structure
6438: AND cbet.cost_base_type = INDIRECT_COST_CODE
6439: AND cbet.expenditure_type = ITEM.expenditure_type

Line 6454: FROM pa_cost_base_exp_types cbet

6450: FROM pa_expenditure_items_all ITEM
6451: WHERE tp_ind_compiled_set_id = compiled_set_id
6452: AND request_id = x_request_id
6453: AND EXISTS (SELECT NULL
6454: FROM pa_cost_base_exp_types cbet
6455: WHERE cbet.cost_base = p_cost_base
6456: AND cbet.cost_plus_structure = p_cost_plus_structure
6457: AND cbet.cost_base_type = INDIRECT_COST_CODE
6458: AND cbet.expenditure_type = ITEM.expenditure_type