APPS.PA_PROJ_STRUCTURE_UTILS dependencies on PA_TASKS

Line 42: pa_tasks t

38: (
39: select
40: project_id
41: from
42: pa_tasks t
43: where
44: t.task_id = p_task_id
45: )
46: start with object_id_from2 = p_project_id

Line 61: pa_tasks t2

57: BEGIN
58: select 'Y'
59: into l_looped
60: from
61: pa_tasks t2
62: where
63: t2.task_id = p_task_id and
64: t2.project_id = p_project_id;
65: EXCEPTION

Line 114: pa_tasks t

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
118: r.relationship_type = 'H' and

Line 122: -- object_type_from = 'PA_TASKS' and

118: r.relationship_type = 'H' and
119: r.object_id_from2 = t.project_id and
120: t.task_id = l_task_id; */
121: -- object_id_from1 = l_task_id and
122: -- object_type_from = 'PA_TASKS' and
123: -- relationship_type = 'H';
124:
125: -- Modified the above cursor for Bug Bug5589038
126: CURSOR get_same_project(l_task_id NUMBER, l_project_id VARCHAR2) IS

Line 130: pa_tasks t

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
134: (r.relationship_type = 'LF' or r.relationship_type = 'LW') and

Line 151: pa_tasks t

147: (
148: select
149: project_id
150: from
151: pa_tasks t
152: where
153: t.task_id = l_task_id
154: )
155: --Bug5589038 connect by PRIOR object_id_from2 = object_id_to1

Line 161: pa_tasks

157: union
158: select
159: project_id
160: from
161: pa_tasks
162: where
163: task_id = l_task_id
164: )
165: intersect