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
195: AND target_pt.project_id = l_to_fp_option_info_rec.project_id
196: AND ee.element_type = DECODE( p_from_element_type,
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
195: AND target_pt.project_id = l_to_fp_option_info_rec.project_id
196: AND ee.element_type = DECODE( p_from_element_type,
197: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,