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_FCST_AMT_PVT dependencies on PA_RES_LIST_MAP_TMP1

Line 2477: DELETE FROM pa_res_list_map_tmp1;

2473: SET rate_based_flag = 'N',
2474: unit_of_measure = 'DOLLARS'
2475: WHERE resource_assignment_id = l_tgt_res_asg_tab(i);
2476:
2477: DELETE FROM pa_res_list_map_tmp1;
2478: FORALL i IN 1..l_tgt_res_asg_tab.count
2479: INSERT INTO pa_res_list_map_tmp1(txn_resource_assignment_id)
2480: VALUES (l_tgt_res_asg_tab(i));
2481:

Line 2479: INSERT INTO pa_res_list_map_tmp1(txn_resource_assignment_id)

2475: WHERE resource_assignment_id = l_tgt_res_asg_tab(i);
2476:
2477: DELETE FROM pa_res_list_map_tmp1;
2478: FORALL i IN 1..l_tgt_res_asg_tab.count
2479: INSERT INTO pa_res_list_map_tmp1(txn_resource_assignment_id)
2480: VALUES (l_tgt_res_asg_tab(i));
2481:
2482: /* bl.bv id check added for perf bug 4183364 */
2483:

Line 2495: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp

2491: l_init_raw_cost_tab,
2492: l_raw_cost_tab,
2493: l_init_rev_tab,
2494: l_rev_tab
2495: FROM pa_budget_lines bl, pa_res_list_map_tmp1 tmp
2496: WHERE bl.budget_version_id = l_bv_id AND
2497: tmp.txn_resource_assignment_id = bl.resource_assignment_id;
2498:
2499: IF l_budget_line_id_tab.count = 0 THEN