DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_TYPES_VL

Line 3252: ,pa_fin_plan_types_vl pt

3248: ,DECODE(pt.plan_class_code,
3249: 'BUDGET','CURRENT_BASELINED',
3250: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3251: FROM pa_proj_fp_options o
3252: ,pa_fin_plan_types_vl pt
3253: WHERE o.project_id = p_target_project_id
3254: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3255: AND o.fin_plan_preference_code <> 'REVENUE_ONLY'
3256: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3392: ,pa_fin_plan_types_vl pt

3388: ,DECODE(pt.plan_class_code,
3389: 'BUDGET','CURRENT_BASELINED',
3390: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3391: FROM pa_proj_fp_options o
3392: ,pa_fin_plan_types_vl pt
3393: WHERE o.project_id = p_target_project_id
3394: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3395: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026
3396: AND o.fin_plan_preference_code <> 'REVENUE_ONLY' -- bug 3666398 'COST_ONLY'

Line 3487: ,pa_fin_plan_types_vl pt

3483: ,DECODE(pt.plan_class_code,
3484: 'BUDGET','CURRENT_BASELINED',
3485: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3486: FROM pa_proj_fp_options o
3487: ,pa_fin_plan_types_vl pt
3488: WHERE o.project_id = p_target_project_id
3489: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3490: AND o.fin_plan_type_id = pt.fin_plan_type_id
3491: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026