DBA Data[Home] [Help]

APPS.PA_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_TASKS

Line 192: pa_tasks source_pt,

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,

Line 193: pa_tasks target_pt

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,