DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJ_WORKPLAN_ATTR

Line 1085: from pa_proj_workplan_attr

1081:
1082: /* Bug 3946599 . This Cursor is Wrong.This will return both Financial as well as WP record
1083: CURSOR c1 IS
1084: select wp_approval_reqd_flag, wp_auto_publish_flag
1085: from pa_proj_workplan_attr
1086: where project_id = p_project_id; */
1087:
1088: -- Bug 3946599 : Included an additional clause in above cursor that
1089: -- The Structure Type is Workplan.

Line 1093: from pa_proj_workplan_attr ppw

1089: -- The Structure Type is Workplan.
1090:
1091: CURSOR c1 IS
1092: select wp_approval_reqd_flag, wp_auto_publish_flag
1093: from pa_proj_workplan_attr ppw
1094: ,pa_proj_structure_types ppst
1095: ,pa_structure_types pst
1096: where ppw.project_id = p_project_id
1097: and ppw.proj_element_id = ppst.proj_element_id

Line 3895: from pa_proj_workplan_attr ppwa,

3891: RETURN VARCHAR2
3892: IS
3893: cursor get_third_party_flag IS
3894: Select ppwa.SCHEDULE_THIRD_PARTY_FLAG
3895: from pa_proj_workplan_attr ppwa,
3896: pa_proj_structure_types ppst,
3897: pa_structure_types pst
3898: where p_project_id = ppwa.project_id
3899: and ppwa.proj_element_id = ppst.proj_element_id

Line 3920: from pa_proj_workplan_attr ppwa,

3916: RETURN VARCHAR2
3917: IS
3918: cursor get_lowest_tsk_dep_flag IS
3919: Select ppwa.ALLOW_LOWEST_TSK_DEP_FLAG
3920: from pa_proj_workplan_attr ppwa,
3921: pa_proj_structure_types ppst,
3922: pa_structure_types pst
3923: where p_project_id = ppwa.project_id
3924: and ppwa.proj_element_id = ppst.proj_element_id