APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 1710: FROM pa_proj_fp_options

1706: FROM
1707: (
1708: SELECT
1709: DECODE(NVL(NVL(cost_time_phased_code, revenue_time_phased_code), all_time_phased_code), 'G', 'G', 'P', 'P', 'A') calendar_type
1710: FROM pa_proj_fp_options
1711: WHERE fin_plan_option_level_code = 'PLAN_VERSION'
1712: AND fin_plan_version_id = l_plan_ver_id
1713: ) ;
1714: EXCEPTION

Line 2487: pa_proj_fp_options fp,

2483: (
2484: SELECT DECODE(NVL(NVL(fp.cost_time_phased_code, fp.revenue_time_phased_code ), fp.all_time_phased_code), 'G', 'G', 'P', 'P', 'A') calendar_type,
2485: pa.ORG_ID
2486: FROM
2487: pa_proj_fp_options fp,
2488: pa_projects_all pa
2489: WHERE 1=1
2490: and pa.project_id=fp.project_id
2491: and pa.project_id=tmp.project_id

Line 3480: , pa_proj_fp_options fpo

3476:
3477: CURSOR c_plan_versions (l_rbs_version_id NUMBER) IS -- This can be combined with the previous cursor.
3478: SELECT bv.budget_version_id, bv.project_id
3479: FROM pa_budget_versions bv
3480: , pa_proj_fp_options fpo
3481: WHERE 1=1
3482: AND bv.budget_version_id = fpo.fin_plan_version_id
3483: AND bv.fin_plan_type_id = fpo.fin_plan_type_id
3484: AND fpo.project_id = bv.project_id