APPS.PA_PROJ_STRUCTURE_UTILS dependencies on PA_TASKS

Line 46: pa_tasks t

42: (
43: select
44: project_id
45: from
46: pa_tasks t
47: where
48: t.task_id = p_task_id
49: )
50: start with object_id_from2 = p_project_id

Line 65: pa_tasks t2

61: BEGIN
62: select 'Y'
63: into l_looped
64: from
65: pa_tasks t2
66: where
67: t2.task_id = p_task_id and
68: t2.project_id = p_project_id;
69: EXCEPTION

Line 118: pa_tasks t

114: CURSOR get_same_project(l_task_id NUMBER, l_project_id VARCHAR2) IS
115: select 'Y'
116: from
117: pa_object_relationships r,
118: pa_tasks t
119: where
120: r.object_id_to1 = l_project_id and
121: r.object_type_to = 'PA_PROJECTS' and
122: r.relationship_type = 'H' and

Line 126: -- object_type_from = 'PA_TASKS' and

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

Line 134: pa_tasks t

130: CURSOR get_same_project(l_task_id NUMBER, l_project_id VARCHAR2) IS
131: select 'Y'
132: from
133: pa_object_relationships r,
134: pa_tasks t
135: where
136: r.object_id_to2 = l_project_id and
137: r.object_type_to = 'PA_STRUCTURES' and
138: (r.relationship_type = 'LF' or r.relationship_type = 'LW') and

Line 160: pa_tasks t

156: (
157: select
158: project_id
159: from
160: pa_tasks t
161: where
162: t.task_id = l_task_id
163: )
164: --Bug5589038 connect by PRIOR object_id_from2 = object_id_to1

Line 170: pa_tasks

166: union
167: select
168: project_id
169: from
170: pa_tasks
171: where
172: task_id = l_task_id
173: )
174: intersect