APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 465: DELETE pa_resource_asgn_curr_tmp;

461:
462:
463: -- IPM: New Entity and Display Quantity ERs --------------------
464:
465: DELETE pa_resource_asgn_curr_tmp;
466:
467: FORALL i IN 1..l_res_asg_id_tab.count
468: INSERT INTO pa_resource_asgn_curr_tmp (
469: resource_assignment_id,

Line 468: INSERT INTO pa_resource_asgn_curr_tmp (

464:
465: DELETE pa_resource_asgn_curr_tmp;
466:
467: FORALL i IN 1..l_res_asg_id_tab.count
468: INSERT INTO pa_resource_asgn_curr_tmp (
469: resource_assignment_id,
470: txn_currency_code )
471: VALUES (
472: l_res_asg_id_tab(i),

Line 477: UPDATE pa_resource_asgn_curr_tmp tmp

473: l_txn_currency_code_tab(i) );
474:
475: -- Bug 5042399: Copy any existing override rates to the tmp table
476: -- so that they will be carried over during the rollup.
477: UPDATE pa_resource_asgn_curr_tmp tmp
478: SET ( TXN_RAW_COST_RATE_OVERRIDE,
479: TXN_BURDEN_COST_RATE_OVERRIDE,
480: TXN_BILL_RATE_OVERRIDE ) =
481: ( SELECT rbc.TXN_RAW_COST_RATE_OVERRIDE,

Line 493: FROM pa_resource_asgn_curr_tmp;

489: SELECT DISTINCT
490: resource_assignment_id
491: BULK COLLECT
492: INTO l_display_qty_ra_id_tab
493: FROM pa_resource_asgn_curr_tmp;
494:
495: -- Populate the display quantity for processed workplan resources
496:
497: IF p_pa_debug_mode = 'Y' THEN