DBA Data[Home] [Help]

APPS.OKE_CLE_PVT dependencies on PA_PROJECTS_ALL

Line 231: SELECT 'x' FROM PA_PROJECTS_ALL

227: x_return_status OUT NOCOPY VARCHAR2
228: ) IS
229:
230: CURSOR l_csr IS
231: SELECT 'x' FROM PA_PROJECTS_ALL
232: WHERE PROJECT_ID = p_cle_rec.PROJECT_ID;
233:
234: l_dummy_val VARCHAR2(1) := '?';
235: l_parent_line_id NUMBER;

Line 265: from pa_projects_all p

261: CURSOR RG IS
262: SELECT 'x' FROM
263: (
264: select p.project_id pid,p.segment1
265: from pa_projects_all p
266: where p.project_id in
267: (select to_number(sub_project_id) project_id
268: from pa_fin_structures_links_v
269: start with parent_project_id = l_project_id_from

Line 275: from pa_projects_all

271: and top_task_id=nvl(l_task_id_from,top_task_id) )
272: connect by parent_project_id = prior sub_project_id)
273: union
274: select project_id pid,segment1
275: from pa_projects_all
276: where project_id = l_project_id_from)
277: WHERE pid = p_cle_rec.PROJECT_ID;
278:
279:

Line 284: from pa_projects_all

280: CURSOR RG3 IS
281: SELECT 'x' FROM
282: (
283: select project_id pid,segment1
284: from pa_projects_all
285: where project_id = l_project_id_from)
286: WHERE pid = p_cle_rec.PROJECT_ID;
287:
288: cursor c_z(x_proj number, x_task number) is /* check is only needed if task is specified as well */