DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PA_BUDGET_VERSIONS

Line 5541: FROM pa_budget_versions bv

5537: AND prv.STATUS_CODE = 'FROZEN';
5538:
5539: CURSOR c_plan_versions (l_rbs_version_id NUMBER) IS
5540: SELECT /*+ parallel(bv) */ bv.budget_version_id, bv.project_id
5541: FROM pa_budget_versions bv
5542: , pa_proj_fp_options fpo
5543: WHERE 1=1
5544: AND bv.budget_version_id = fpo.fin_plan_version_id
5545: AND bv.fin_plan_type_id = fpo.fin_plan_type_id

Line 5663: PA_BUDGET_VERSIONS bv

5659: nvl(fpo.all_time_phased_code,nvl(fpo.cost_time_phased_code,fpo.revenue_time_phased_code)) time_phased_code
5660: from
5661: PJI_PJP_PROJ_BATCH_MAP map,
5662: PA_PROJ_FP_OPTIONS fpo,
5663: PA_BUDGET_VERSIONS bv
5664: where
5665: map.WORKER_ID = p_worker_id and
5666: fpo.FIN_PLAN_TYPE_ID = nvl(l_plan_type_id,fpo.FIN_PLAN_TYPE_ID) and
5667: fpo.PROJECT_ID = map.PROJECT_ID and