APPS.PA_FP_WEBADI_PKG dependencies on PA_PROJ_ELEMENTS

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

2086: IF l_rl_control_flag = 'N' THEN
2087: -- updating the rlm ids for categorized resource lists with control_fl as N
2088: UPDATE pa_fp_webadi_upload_inf inf
2089: SET inf.task_id = (SELECT pt.task_id
2090: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2091: pt.element_number task_number,
2092: pt.proj_element_id task_id
2093: FROM pa_proj_elements pt
2094: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2093: FROM pa_proj_elements pt

2089: SET inf.task_id = (SELECT pt.task_id
2090: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2091: pt.element_number task_number,
2092: pt.proj_element_id task_id
2093: FROM pa_proj_elements pt
2094: WHERE pt.project_id = p_version_info_rec.x_project_id
2095: AND object_type = 'PA_TASKS'
2096: AND parent_structure_id = l_fin_struct_id
2097: UNION ALL

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

2216: ELSE -- control_flag = Y
2217: -- updating the rlm ids for categorized resource lists with control_fl as Y
2218: UPDATE pa_fp_webadi_upload_inf inf
2219: SET inf.task_id = (SELECT pt.task_id
2220: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2221: pt.element_number task_number,
2222: pt.proj_element_id task_id
2223: FROM pa_proj_elements pt
2224: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2223: FROM pa_proj_elements pt

2219: SET inf.task_id = (SELECT pt.task_id
2220: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2221: pt.element_number task_number,
2222: pt.proj_element_id task_id
2223: FROM pa_proj_elements pt
2224: WHERE pt.project_id = p_version_info_rec.x_project_id
2225: AND object_type = 'PA_TASKS'
2226: AND parent_structure_id = l_fin_struct_id
2227: UNION ALL

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

2360: --DEBUG_NS('l_unct_rlm_id :: ' ||l_unct_rlm_id);
2361:
2362: UPDATE pa_fp_webadi_upload_inf inf
2363: SET inf.task_id = (SELECT pt.task_id
2364: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/
2365: pt.element_number task_number,
2366: pt.proj_element_id task_id
2367: FROM pa_proj_elements pt
2368: WHERE pt.project_id = p_version_info_rec.x_project_id

Line 2367: FROM pa_proj_elements pt

2363: SET inf.task_id = (SELECT pt.task_id
2364: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/
2365: pt.element_number task_number,
2366: pt.proj_element_id task_id
2367: FROM pa_proj_elements pt
2368: WHERE pt.project_id = p_version_info_rec.x_project_id
2369: AND object_type = 'PA_TASKS'
2370: AND parent_structure_id = l_fin_struct_id
2371: UNION ALL

Line 12112: pa_proj_elements pe,

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,
12113: pa_proj_element_versions pev,
12114: pa_resource_list_members prlm,
12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,