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_PUB dependencies on PA_FP_GEN_RATE_TMP

Line 1721: DELETE pa_fp_gen_rate_tmp;

1717:
1718: /* Use temporary table to Bulk process resources.
1719: * We use the target_res_asg_id column instead of source_res_asg_id
1720: * so that we can make use of the index on the temp table. */
1721: DELETE pa_fp_gen_rate_tmp;
1722: FORALL i IN 1..p_src_res_asg_id_tab.count
1723: INSERT INTO pa_fp_gen_rate_tmp
1724: ( target_res_asg_id )
1725: VALUES ( p_src_res_asg_id_tab(i) );

Line 1723: INSERT INTO pa_fp_gen_rate_tmp

1719: * We use the target_res_asg_id column instead of source_res_asg_id
1720: * so that we can make use of the index on the temp table. */
1721: DELETE pa_fp_gen_rate_tmp;
1722: FORALL i IN 1..p_src_res_asg_id_tab.count
1723: INSERT INTO pa_fp_gen_rate_tmp
1724: ( target_res_asg_id )
1725: VALUES ( p_src_res_asg_id_tab(i) );
1726:
1727: -- SQL Repository Bug 4884824; SQL ID 14902567

Line 1748: FROM pa_fp_gen_rate_tmp tmp,

1744: INTO l_quantity,
1745: l_txn_raw_cost,
1746: l_txn_burdened_cost,
1747: l_txn_revenue
1748: FROM pa_fp_gen_rate_tmp tmp,
1749: pa_budget_lines sbl
1750: WHERE tmp.target_res_asg_id = sbl.resource_assignment_id
1751: and sbl.budget_version_id = l_source_bv_id
1752: and sbl.period_name = l_source_period_name