DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_TYPES_VL

Line 3207: ,pa_fin_plan_types_vl pt

3203: ,DECODE(pt.plan_class_code,
3204: 'BUDGET','CURRENT_BASELINED',
3205: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3206: FROM pa_proj_fp_options o
3207: ,pa_fin_plan_types_vl pt
3208: WHERE o.project_id = p_target_project_id
3209: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3210: AND o.fin_plan_preference_code <> 'REVENUE_ONLY'
3211: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3347: ,pa_fin_plan_types_vl pt

3343: ,DECODE(pt.plan_class_code,
3344: 'BUDGET','CURRENT_BASELINED',
3345: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3346: FROM pa_proj_fp_options o
3347: ,pa_fin_plan_types_vl pt
3348: WHERE o.project_id = p_target_project_id
3349: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3350: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026
3351: AND o.fin_plan_preference_code <> 'REVENUE_ONLY' -- bug 3666398 'COST_ONLY'

Line 3442: ,pa_fin_plan_types_vl pt

3438: ,DECODE(pt.plan_class_code,
3439: 'BUDGET','CURRENT_BASELINED',
3440: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3441: FROM pa_proj_fp_options o
3442: ,pa_fin_plan_types_vl pt
3443: WHERE o.project_id = p_target_project_id
3444: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3445: AND o.fin_plan_type_id = pt.fin_plan_type_id
3446: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026