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_TASKS

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 2095: AND object_type = '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
2098: SELECT p.long_name task_name, /* Bug 5345336 */
2099: p.segment1 task_number,

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 2225: AND object_type = '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
2228: SELECT p.long_name task_name, /* Bug 5345336 */
2229: p.segment1 task_number,

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 2369: AND object_type = '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
2372: SELECT p.long_name task_name, /* Bug 5345336 */
2373: p.segment1 task_number,

Line 6163: p_task_id IN pa_tasks.task_id%TYPE,

6159: --This API is internally called from prepare_pbl_input
6160: PROCEDURE get_total_fcst_amounts
6161: (p_project_id IN pa_projects_all.project_id%TYPE,
6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6163: p_task_id IN pa_tasks.task_id%TYPE,
6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106
6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6167: p_line_start_date IN DATE,

Line 12130: AND pe.object_type(+)='PA_TASKS'

12126: AND pra.resource_list_member_id = prlm.resource_list_member_id
12127: AND decode(pra.task_id,0,pev.proj_element_id,pra.task_id)=pev.proj_element_id
12128: AND decode(pra.task_id,0,pev.parent_structure_version_id,pev.element_version_id)=pev.element_version_id
12129: AND pev.proj_element_id = pe.proj_element_id(+)
12130: AND pe.object_type(+)='PA_TASKS'
12131: AND pev.parent_structure_version_id = c_parent_structure_version_id
12132: AND nvl(pra.spread_curve_id,1) = psc.spread_curve_id
12133: AND etc.lookup_type = 'PA_FP_ETC_METHOD'
12134: AND etc.lookup_code(+) = pra.etc_method_code