DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FIN_PLAN_TYPES_VL

Line 264: ,pa_fin_plan_types_vl pt

260: CURSOR def_gen_src_plan_type_cur (c_project_id NUMBER, c_fin_plan_type_id NUMBER)IS
261: SELECT pt.fin_plan_type_id as fin_plan_type_id
262: ,pt.plan_class_code as plan_class_code
263: FROM pa_proj_fp_options o
264: ,pa_fin_plan_types_vl pt
265: WHERE o.project_id = c_project_id
266: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
267: AND o.fin_plan_type_id <> c_fin_plan_type_id
268: AND o.fin_plan_preference_code <> 'REVENUE_ONLY'