142: ,l_to_fp_option_info_rec.fin_plan_version_id fin_plan_version_id
143: ,ee.task_id task_id
144: ,1 record_version_number
145: ,sysdate last_update_date
146: ,fnd_global.user_id last_updated_by
147: ,sysdate creation_date
148: ,fnd_global.user_id created_by
149: ,fnd_global.login_id last_update_login
150: FROM
144: ,1 record_version_number
145: ,sysdate last_update_date
146: ,fnd_global.user_id last_updated_by
147: ,sysdate creation_date
148: ,fnd_global.user_id created_by
149: ,fnd_global.login_id last_update_login
150: FROM
151: pa_fp_excluded_elements ee
152: WHERE ee.proj_fp_options_id = p_from_proj_fp_options_id
145: ,sysdate last_update_date
146: ,fnd_global.user_id last_updated_by
147: ,sysdate creation_date
148: ,fnd_global.user_id created_by
149: ,fnd_global.login_id last_update_login
150: FROM
151: pa_fp_excluded_elements ee
152: WHERE ee.proj_fp_options_id = p_from_proj_fp_options_id
153: AND ee.element_type = DECODE( p_from_element_type,
183: ,l_to_fp_option_info_rec.fin_plan_version_id fin_plan_version_id
184: ,target_pt.task_id task_id
185: ,1 record_version_number
186: ,sysdate last_update_date
187: ,fnd_global.user_id last_updated_by
188: ,sysdate creation_date
189: ,fnd_global.user_id created_by
190: ,fnd_global.login_id last_update_login
191: FROM pa_fp_excluded_elements ee,
185: ,1 record_version_number
186: ,sysdate last_update_date
187: ,fnd_global.user_id last_updated_by
188: ,sysdate creation_date
189: ,fnd_global.user_id created_by
190: ,fnd_global.login_id last_update_login
191: FROM pa_fp_excluded_elements ee,
192: pa_tasks source_pt,
193: pa_tasks target_pt
186: ,sysdate last_update_date
187: ,fnd_global.user_id last_updated_by
188: ,sysdate creation_date
189: ,fnd_global.user_id created_by
190: ,fnd_global.login_id last_update_login
191: FROM pa_fp_excluded_elements ee,
192: pa_tasks source_pt,
193: pa_tasks target_pt
194: WHERE proj_fp_options_id = p_from_proj_fp_options_id