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_GEN_BUDGET_AMT_PUB dependencies on PA_FP_CALC_AMT_TMP2

Line 4188: delete from pa_fp_calc_amt_tmp2;

4184: -- Bug 4549862: Moved initialization of l_rev_gen_method before
4185: -- initialization of l_calculate_mode earlier in the code.
4186:
4187: IF p_fp_cols_rec.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
4188: delete from pa_fp_calc_amt_tmp2;
4189:
4190: FOR i IN 1..l_res_assgn_id_tmp_tab.count LOOP
4191: SELECT SUM(quantity)
4192: INTO l_total_plan_quantity

Line 4196: INSERT INTO pa_fp_calc_amt_tmp2(

4192: INTO l_total_plan_quantity
4193: FROM pa_budget_lines
4194: WHERE resource_assignment_id = l_res_assgn_id_tmp_tab(i); /* Bug 4093872 - Column name corrected from budget_version_id to resource_assignment_id */
4195:
4196: INSERT INTO pa_fp_calc_amt_tmp2(
4197: resource_assignment_id,
4198: total_plan_quantity)
4199: VALUES(
4200: l_res_assgn_id_tmp_tab(i),

Line 6333: SELECT /+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)/

6329: p_module_name => l_module_name,
6330: p_log_level => 5);
6331: END IF;
6332:
6333: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
6334: tmp.RESOURCE_ASSIGNMENT_ID,
6335: tmp.total_plan_quantity,
6336: ra.task_id,
6337: ra.resource_list_member_id,

Line 6431: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,

6427: l_rev_res_class_rt_sch_id_tab,
6428: l_cost_res_class_rt_sch_id_tab,
6429:
6430: l_res_format_id_tab
6431: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6432: pa_projects_all proj, pa_tasks t,
6433: pa_proj_fp_options fp,
6434: pa_resource_list_members rlm
6435: WHERE tmp.resource_assignment_id = ra.resource_assignment_id

Line 6975: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,