APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_RES_LIST_MAP_TMP4

Line 2542: * The temp table pa_res_list_map_tmp4 must be populated.

2538: * considered for synching. The pji_fm_xbs_accum_tmp1
2539: * table should be populated before calling this procedure.
2540: *
2541: * GEN_COMMITMENTS : Target resources with commitments are considered.
2542: * The temp table pa_res_list_map_tmp4 must be populated.
2543: * Please see the Technical Design for details:
2544: *
2545: * http://files.oraclecorp.com/content/MySharedFolders/
2546: * Projects%20Development%20-%20Projects/30.Family%20Pack

Line 2754: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/

2750:
2751: /* Cursor for synching Commitments and Billing Events */
2752:
2753: CURSOR cmt_bill_event_dates_cursor IS
2754: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2755: ra.resource_assignment_id,
2756: ra.planning_start_date,
2757: ra.planning_end_date,
2758: MIN(tmp.txn_planning_start_date),

Line 2760: FROM pa_res_list_map_tmp4 tmp,

2756: ra.planning_start_date,
2757: ra.planning_end_date,
2758: MIN(tmp.txn_planning_start_date),
2759: MAX(tmp.txn_planning_end_date)
2760: FROM pa_res_list_map_tmp4 tmp,
2761: pa_resource_assignments ra
2762: WHERE ra.resource_assignment_id = tmp.txn_resource_assignment_id
2763: AND ra.budget_version_id = p_budget_version_id
2764: GROUP BY ra.resource_assignment_id,