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.

[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_RBS_ELEMENTS

Line 2207: (select pre.rbs_element_id from pa_rbs_elements pre where

2203: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2204: AND rlm.object_type = 'PROJECT'
2205: AND rlm.object_id = p_version_info_rec.x_project_id),
2206: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2207: (select pre.rbs_element_id from pa_rbs_elements pre where
2208: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2209: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2210:
2211: WHERE inf.run_id= p_run_id

Line 2337: (select pre.rbs_element_id from pa_rbs_elements pre where

2333: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2334: AND rlm.object_type = 'RESOURCE_LIST'
2335: AND rlm.object_id = p_version_info_rec.x_resource_list_id),
2336: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2337: (select pre.rbs_element_id from pa_rbs_elements pre where
2338: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2339: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2340: WHERE inf.run_id= p_run_id
2341: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);

Line 2476: (select pre.rbs_element_id from pa_rbs_elements pre where

2472: inf.prd52 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd52 ),
2473: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2474: inf.resource_list_member_id = l_unct_rlm_id,
2475: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2476: (select pre.rbs_element_id from pa_rbs_elements pre where
2477: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2478: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2479: WHERE inf.run_id= p_run_id
2480: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);

Line 12107: (select COST_CODE from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code, -- cbs enhancement changes bug#16445106

12103: pftc.project_cost_exchange_rate project_cost_exchange_rate,
12104: pftc.project_rev_exchange_rate project_rev_exchange_rate,
12105: pftc.projfunc_cost_exchange_rate projfunc_cost_exchange_rate,
12106: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate,
12107: (select COST_CODE from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code, -- cbs enhancement changes bug#16445106
12108: (select COST_CODE_NAME from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code_name -- cbs enhancement changes bug#16445106
12109: FROM pa_resource_assignments pra,
12110: pa_resource_asgn_curr prac,
12111: pa_fp_txn_currencies pftc,

Line 12108: (select COST_CODE_NAME from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code_name -- cbs enhancement changes bug#16445106

12104: pftc.project_rev_exchange_rate project_rev_exchange_rate,
12105: pftc.projfunc_cost_exchange_rate projfunc_cost_exchange_rate,
12106: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate,
12107: (select COST_CODE from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code, -- cbs enhancement changes bug#16445106
12108: (select COST_CODE_NAME from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code_name -- cbs enhancement changes bug#16445106
12109: FROM pa_resource_assignments pra,
12110: pa_resource_asgn_curr prac,
12111: pa_fp_txn_currencies pftc,
12112: pa_proj_elements pe,