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

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

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

Line 6070: p_task_id IN pa_tasks.task_id%TYPE,

6066: --This API is internally called from prepare_pbl_input
6067: PROCEDURE get_total_fcst_amounts
6068: (p_project_id IN pa_projects_all.project_id%TYPE,
6069: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6070: p_task_id IN pa_tasks.task_id%TYPE,
6071: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6072: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6073: p_line_start_date IN DATE,
6074: p_line_end_date IN DATE,

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

11893: AND pra.resource_list_member_id = prlm.resource_list_member_id
11894: AND decode(pra.task_id,0,pev.proj_element_id,pra.task_id)=pev.proj_element_id
11895: AND decode(pra.task_id,0,pev.parent_structure_version_id,pev.element_version_id)=pev.element_version_id
11896: AND pev.proj_element_id = pe.proj_element_id(+)
11897: AND pe.object_type(+)='PA_TASKS'
11898: AND pev.parent_structure_version_id = c_parent_structure_version_id
11899: AND nvl(pra.spread_curve_id,1) = psc.spread_curve_id
11900: AND etc.lookup_type = 'PA_FP_ETC_METHOD'
11901: AND etc.lookup_code(+) = pra.etc_method_code