DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_WORKPLAN_ATTR

Line 382: FROM pa_proj_workplan_attr

378: l_default_outline_lvl NUMBER;
379:
380: CURSOR l_get_workplan_attrs_csr(c_project_id IN NUMBER) IS
381: SELECT wp_approval_reqd_flag, wp_auto_publish_flag, wp_approver_source_id, wp_approver_source_type, wp_default_display_lvl
382: FROM pa_proj_workplan_attr
383: WHERE project_id = c_project_id;
384: */
385:
386: /* below cursor added for bug 2588244 */

Line 6224: FROM pa_proj_workplan_attr ppwa

6220: WHERE context = 'WORKPLAN';
6221:
6222: CURSOR cur_get_wp_attr IS
6223: SELECT ppwa.*
6224: FROM pa_proj_workplan_attr ppwa
6225: ,pa_proj_structure_types ppst
6226: ,pa_structure_types pst
6227: WHERE ppwa.project_id = p_src_project_id
6228: AND ppwa.proj_element_id = ppst.proj_element_id