APPS.GHR_MTO_PKG dependencies on PER_ORGANIZATION_UNITS

Line 173: from per_organization_units b

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'

Line 223: per_organization_units punits

219: punits.name ORGANIZATION_NAME
220: from per_assignments_f paf,
221: per_people_f ppf,
222: per_person_types ppt,
223: per_organization_units punits
224: -- VSM added nvl( .. to the start... clause
225: -- enhancement in selection criteria as org_id can be be null [Masscrit.doc]
226: where (paf.organization_id = nvl(p_org_id, paf.organization_id)
227: and

Line 260: per_organization_units punits

256: punits.name ORGANIZATION_NAME
257: from per_assignments_f paf,
258: per_people_f ppf,
259: per_person_types ppt,
260: per_organization_units punits
261: where (paf.position_id = nvl(p_org_id,paf.position_id)
262: and
263: org_pos_fl = 'P')
264: and ppf.person_id = paf.person_id

Line 297: per_organization_units punits

293: pop.BUSINESS_GROUP_ID,
294: punits.name ORGANIZATION_NAME,
295: pop.availability_status_id
296: from hr_positions_f pop,
297: per_organization_units punits
298: where pop.position_id in
299: (
300: select position_id POSITION_ID
301: from hr_positions_f

Line 1614: from ghr_pa_requests /**, per_organization_units B*/

1610: FROM_OCC_CODE,
1611: TO_ORGANIZATION_ID ORGANIZATION_ID,
1612: ---B.NAME ORGANIZATION_NAME,
1613: EMPLOYEE_ASSIGNMENT_ID
1614: from ghr_pa_requests /**, per_organization_units B*/
1615: where person_id = p_person_id
1616: and effective_date = p_effective_date
1617: and first_noa_code = '352'
1618: -- Added by Dinkar for reports