APPS.PA_PROJ_STRUCTURE_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 34: pa_object_relationships r

30: --check if it is looped
31: select 'Y'
32: into l_looped
33: from
34: pa_object_relationships r
35: where
36: -- Bug 5589038 object_id_to1 =
37: object_id_to2 =
38: (

Line 105: l_linked_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_FROM2%TYPE;

101: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
102: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103: )
104: IS
105: l_linked_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_FROM2%TYPE;
106: l_exist VARCHAR2(1);
107: l_linked VARCHAR2(1);
108:
109: /* Commented for Bug5589038

Line 113: pa_object_relationships r,

109: /* Commented for Bug5589038
110: CURSOR get_same_project(l_task_id NUMBER, l_project_id VARCHAR2) IS
111: select 'Y'
112: from
113: pa_object_relationships r,
114: pa_tasks t
115: where
116: r.object_id_to1 = l_project_id and
117: r.object_type_to = 'PA_PROJECTS' and

Line 129: pa_object_relationships r,

125: -- Modified the above cursor for Bug Bug5589038
126: CURSOR get_same_project(l_task_id NUMBER, l_project_id VARCHAR2) IS
127: select 'Y'
128: from
129: pa_object_relationships r,
130: pa_tasks t
131: where
132: r.object_id_to2 = l_project_id and
133: r.object_type_to = 'PA_STRUCTURES' and

Line 143: pa_object_relationships

139: (
140: select
141: object_id_from2
142: from
143: pa_object_relationships
144: start with
145: -- Bug5589038 object_id_to1 =
146: object_id_to2 =
147: (

Line 169: pa_object_relationships

165: intersect
166: select
167: object_id_from2
168: from
169: pa_object_relationships
170: -- Bug5589038 start with object_id_to1 = l_project_id
171: start with object_id_to2 = l_project_id
172: -- Bug5589038 connect by PRIOR object_id_from2 = object_id_to1;
173: connect by PRIOR object_id_from2 = object_id_to2;