DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_WORKPLAN_ATTR

Line 378: FROM pa_proj_workplan_attr

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

Line 6156: FROM pa_proj_workplan_attr ppwa

6152: WHERE context = 'WORKPLAN';
6153:
6154: CURSOR cur_get_wp_attr IS
6155: SELECT ppwa.*
6156: FROM pa_proj_workplan_attr ppwa
6157: ,pa_proj_structure_types ppst
6158: ,pa_structure_types pst
6159: WHERE ppwa.project_id = p_src_project_id
6160: AND ppwa.proj_element_id = ppst.proj_element_id