DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PJI_FM_XBS_ACCUM_TMP1

Line 2538: * considered for synching. The pji_fm_xbs_accum_tmp1

2534: * planning start/end dates (instead of their periods).
2535: *
2536: * COPY_ACTUALS : Has the same behavior as SYNC_VERSION_LEVEL, with the
2537: * exception that only target resources with actuals are
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.

Line 2679: pji_fm_xbs_accum_tmp1 pji_tmp,

2675: max(bl.end_date)
2676: FROM pa_resource_assignments ra,
2677: pa_budget_versions bv, -- Added for Perf Bug 4469690
2678: pa_budget_lines bl,
2679: pji_fm_xbs_accum_tmp1 pji_tmp,
2680: pa_periods_all start_pd,
2681: pa_periods_all end_pd
2682: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2683: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2708: pji_fm_xbs_accum_tmp1 pji_tmp,

2704: max(bl.end_date)
2705: FROM pa_resource_assignments ra,
2706: pa_budget_versions bv, -- Added for Perf Bug 4469690
2707: pa_budget_lines bl,
2708: pji_fm_xbs_accum_tmp1 pji_tmp,
2709: gl_period_statuses start_pd,
2710: gl_period_statuses end_pd
2711: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2712: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2741: pji_fm_xbs_accum_tmp1 pji_tmp

2737: max(bl.end_date)
2738: FROM pa_resource_assignments ra,
2739: pa_budget_versions bv, -- Added for Perf Bug 4469690
2740: pa_budget_lines bl,
2741: pji_fm_xbs_accum_tmp1 pji_tmp
2742: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2743: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2744: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2745: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690