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_FP_WEBADI_PKG dependencies on PA_PROJ_ELEMENTS

Line 2074: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/

2070: IF l_rl_control_flag = 'N' THEN
2071: -- updating the rlm ids for categorized resource lists with control_fl as N
2072: UPDATE pa_fp_webadi_upload_inf inf
2073: SET inf.task_id = (SELECT pt.task_id
2074: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2075: pt.element_number task_number,
2076: pt.proj_element_id task_id
2077: FROM pa_proj_elements pt
2078: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2077: FROM pa_proj_elements pt

2073: SET inf.task_id = (SELECT pt.task_id
2074: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2075: pt.element_number task_number,
2076: pt.proj_element_id task_id
2077: FROM pa_proj_elements pt
2078: WHERE pt.project_id = p_version_info_rec.x_project_id
2079: AND object_type = 'PA_TASKS'
2080: AND parent_structure_id = l_fin_struct_id
2081: UNION ALL

Line 2197: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/

2193: ELSE -- control_flag = Y
2194: -- updating the rlm ids for categorized resource lists with control_fl as Y
2195: UPDATE pa_fp_webadi_upload_inf inf
2196: SET inf.task_id = (SELECT pt.task_id
2197: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2198: pt.element_number task_number,
2199: pt.proj_element_id task_id
2200: FROM pa_proj_elements pt
2201: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2200: FROM pa_proj_elements pt

2196: SET inf.task_id = (SELECT pt.task_id
2197: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2198: pt.element_number task_number,
2199: pt.proj_element_id task_id
2200: FROM pa_proj_elements pt
2201: WHERE pt.project_id = p_version_info_rec.x_project_id
2202: AND object_type = 'PA_TASKS'
2203: AND parent_structure_id = l_fin_struct_id
2204: UNION ALL

Line 2335: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/

2331:
2332: --log1('----- STAGE 3.4------- '||l_unct_rlm_id);
2333: UPDATE pa_fp_webadi_upload_inf inf
2334: SET inf.task_id = (SELECT pt.task_id
2335: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/
2336: pt.element_number task_number,
2337: pt.proj_element_id task_id
2338: FROM pa_proj_elements pt
2339: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2338: FROM pa_proj_elements pt

2334: SET inf.task_id = (SELECT pt.task_id
2335: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/
2336: pt.element_number task_number,
2337: pt.proj_element_id task_id
2338: FROM pa_proj_elements pt
2339: WHERE pt.project_id = p_version_info_rec.x_project_id
2340: AND object_type = 'PA_TASKS'
2341: AND parent_structure_id = l_fin_struct_id
2342: UNION ALL

Line 11879: pa_proj_elements pe,

11875: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate
11876: FROM pa_resource_assignments pra,
11877: pa_resource_asgn_curr prac,
11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,