DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 880: , pa_proj_fp_options fpo -- @pjdev115 fpo

876: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
877: , 'N' SECONDARY_RBS_FLAG
878: FROM
879: pa_budget_versions bv -- @pjdev115 bv
880: , pa_proj_fp_options fpo -- @pjdev115 fpo
881: , pa_projects_all ppa -- @pjdev115 ppa
882: WHERE 1=1
883: AND ppa.project_id = bv.project_id
884: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 942: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?

938: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
939: , 'N' SECONDARY_RBS_FLAG
940: FROM
941: pa_budget_versions bv -- @pjdev115 bv
942: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
943: , pa_projects_all ppa -- @pjdev115 ppa
944: WHERE 1=1
945: AND ppa.project_id = bv.project_id
946: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 1008: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?

1004: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1005: , 'Y' SECONDARY_RBS_FLAG
1006: FROM
1007: pa_budget_versions bv -- @pjdev115 bv
1008: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
1009: , pa_projects_all ppa -- @pjdev115 ppa
1010: , PA_RBS_PRJ_ASSIGNMENTS rpa
1011: WHERE 1=1
1012: AND ppa.project_id = bv.project_id

Line 1116: , pa_proj_fp_options fpo -- @pjdev115 fpo

1112: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1113: , 'N' SECONDARY_RBS_FLAG
1114: FROM
1115: pa_budget_versions bv -- @pjdev115 bv
1116: , pa_proj_fp_options fpo -- @pjdev115 fpo
1117: , pa_projects_all ppa -- @pjdev115 ppa
1118: WHERE 1=1
1119: AND ppa.project_id = bv.project_id
1120: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 1183: , pa_proj_fp_options fpo -- @pjdev115 fpo

1179: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1180: , 'N' SECONDARY_RBS_FLAG
1181: FROM
1182: pa_budget_versions bv -- @pjdev115 bv
1183: , pa_proj_fp_options fpo -- @pjdev115 fpo
1184: , pa_projects_all ppa -- @pjdev115 ppa
1185: WHERE 1=1
1186: AND ppa.project_id = bv.project_id
1187: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 1254: , pa_proj_fp_options fpo -- @pjdev115 fpo

1250: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1251: , 'Y' SECONDARY_RBS_FLAG
1252: FROM
1253: pa_budget_versions bv -- @pjdev115 bv
1254: , pa_proj_fp_options fpo -- @pjdev115 fpo
1255: , pa_projects_all ppa -- @pjdev115 ppa
1256: , PA_RBS_PRJ_ASSIGNMENTS rpa
1257: WHERE 1=1
1258: AND ppa.project_id = bv.project_id

Line 4368: , pa_proj_fp_options fpo -- @pjdev115 fpo

4364: , rl.PLAN_TYPE_CODE /* 4471527 */
4365: FROM
4366: pji_fp_xbs_accum_f rl
4367: , pa_budget_versions bv -- @pjdev115 bv
4368: , pa_proj_fp_options fpo -- @pjdev115 fpo
4369: WHERE
4370: rl.project_id = bv.project_id
4371: AND bv.version_type IS NOT NULL
4372: AND bv.fin_plan_type_id IS NOT NULL

Line 5006: , pa_proj_fp_options fpo

5002: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
5003: , 'N'
5004: FROM PJI_FM_EXTR_PLAN_LINES epl
5005: , pa_budget_versions bv
5006: , pa_proj_fp_options fpo
5007: WHERE
5008: epl.plan_version_id = bv.budget_version_id
5009: AND fpo.project_id = bv.project_id
5010: AND bv.fin_plan_type_id = fpo.fin_plan_type_id