APPS.HRBISORGPARAMS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 252: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6

248: , cp_organization_id Number
249: , cp_organization_process Varchar2 )
250: is
251: select TREE.organization_id_start
252: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6
253: , (select ele.organization_id_parent organization_id_start
254: from per_org_structure_elements ele
255: where ele.org_structure_version_id = cp_org_structure_version_id
256: and cp_organization_process in ('ISNR', 'ISRO')

Line 264: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6

260: and ele.org_structure_version_id = cp_org_structure_version_id) TREE
261: where TREE.organization_id_start = org.organization_id
262: UNION
263: select TREE.organization_id_start
264: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6
265: , (select ele.organization_id_child organization_id_start
266: from per_org_structure_elements ele
267: where ele.org_structure_version_id = cp_org_structure_version_id
268: and cp_organization_process in ('ISNR', 'ISRO')

Line 276: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6

272: and ele.org_structure_version_id = cp_org_structure_version_id) TREE
273: where TREE.organization_id_start = org.organization_id
274: UNION
275: select org.organization_id organization_id_start
276: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6
277: where org.organization_id = cp_organization_id
278: order by 1;
279: -----------------------------------------------------------------------
280: --

Line 316: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6

312: , cp_organization_process Varchar2 )
313: is
314: select TREE.organization_id_group
315: , TREE.organization_id_child
316: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6
317: , (select cp_organization_id_start organization_id_group
318: , ele.organization_id_child organization_id_child
319: from per_org_structure_elements ele
320: where ele.org_structure_version_id = cp_org_structure_version_id

Line 331: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6

327: where TREE.organization_id_child = org.organization_id
328: UNION
329: select org.organization_id organization_id_group
330: , org.organization_id organization_id_child
331: from hr_all_organization_units org -- cbridge 05-DEC-2000 115.6
332: where org.organization_id = cp_organization_id_start
333: order by 1,2;
334: --
335: l_osv_id Number := GetOrgStructureVersionID (p_organization_structure_id);

Line 525: from hr_all_organization_units -- S.Bhattal, 18-AUG-99, 115.2 -- cbridge 05-DEC-2000 115.6

521: from per_org_structure_elements
522: where org_structure_version_id = cp_ost_id
523: UNION
524: select organization_id
525: from hr_all_organization_units -- S.Bhattal, 18-AUG-99, 115.2 -- cbridge 05-DEC-2000 115.6
526: where organization_id = cp_org_id;
527: --
528: --
529: l_sql_stmt VARCHAR2(2000);