APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_RESOURCE_ASGN_CURR

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 484: FROM pa_resource_asgn_curr rbc

480: TXN_BILL_RATE_OVERRIDE ) =
481: ( SELECT rbc.TXN_RAW_COST_RATE_OVERRIDE,
482: rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
483: rbc.TXN_BILL_RATE_OVERRIDE
484: FROM pa_resource_asgn_curr rbc
485: WHERE rbc.resource_assignment_id = tmp.resource_assignment_id
486: AND rbc.txn_currency_code = tmp.txn_currency_code );
487:
488: -- Get distinct workplan ra_ids for later processing.

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