[Home] [Help]
169: connect by prior organization_id_child = organization_id_parent
170: )
171: union
172: select b.ORGANIZATION_ID org_pos_id
173: from per_organization_units b
174: -- VSM added nvl( .. to the start... clause
175: -- enhancement in selection criteria as org_id can be be null [Masscrit.doc]
176: where b.organization_id = nvl(cp_orgid, b.organization_id)
177: and org_pos_fl = 'O'
224: punits.name ORGANIZATION_NAME
225: from per_assignments_f paf,
226: per_people_f ppf,
227: per_person_types ppt,
228: per_organization_units punits
229: -- VSM added nvl( .. to the start... clause
230: -- enhancement in selection criteria as org_id can be be null [Masscrit.doc]
231: where (paf.organization_id = nvl(p_org_id, paf.organization_id)
232: and
267: punits.name ORGANIZATION_NAME
268: from per_assignments_f paf,
269: per_people_f ppf,
270: per_person_types ppt,
271: per_organization_units punits
272: where (paf.position_id = nvl(p_org_id,paf.position_id)
273: and
274: org_pos_fl = 'P')
275: and ppf.person_id = paf.person_id
312: pop.BUSINESS_GROUP_ID,
313: punits.name ORGANIZATION_NAME,
314: pop.availability_status_id
315: from hr_positions_f pop,
316: per_organization_units punits
317: where pop.position_id in
318: (
319: select position_id POSITION_ID
320: from hr_positions_f
1715: FROM_OCC_CODE,
1716: TO_ORGANIZATION_ID ORGANIZATION_ID,
1717: ---B.NAME ORGANIZATION_NAME,
1718: EMPLOYEE_ASSIGNMENT_ID
1719: from ghr_pa_requests /**, per_organization_units B*/
1720: where person_id = p_person_id
1721: and effective_date = p_effective_date
1722: and first_noa_code = '352'
1723: -- Added by Dinkar for reports