APPS.GHR_MRE_PKG dependencies on PER_ORGANIZATION_UNITS

Line 48: from per_organization_units b

44: connect by prior organization_id_child = organization_id_parent
45: )
46: union
47: SELECT b.ORGANIZATION_ID org_pos_id
48: from per_organization_units b
49: -- VSM added nvl( .. to the start... clause
50: -- enhancement in SELECTion criteria as org_id can be be null [Masscrit.doc]
51: WHERE b.organization_id = nvl(cp_org_pos_id, b.organization_id)
52: and b.business_group_id = g_business_group_id

Line 102: per_organization_units punits

98: punits.name ORGANIZATION_NAME
99: from per_assignments_f paf,
100: per_people_f ppf,
101: per_person_types ppt,
102: per_organization_units punits
103: -- VSM added nvl( .. to the start... clause
104: -- enhancement in SELECTion criteria as org_id can be be null [Masscrit.doc]
105: WHERE (paf.organization_id = nvl(p_org_pos_id, paf.organization_id)
106: and

Line 142: per_organization_units punits

138: punits.name ORGANIZATION_NAME
139: from per_assignments_f paf,
140: per_people_f ppf,
141: per_person_types ppt,
142: per_organization_units punits
143: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
144: and
145: org_pos_fl = 'P')
146: and ppf.person_id = paf.person_id

Line 184: per_organization_units punits

180: pop.BUSINESS_GROUP_ID,
181: punits.name ORGANIZATION_NAME,
182: pop.availability_status_id
183: from hr_positions_f pop,
184: per_organization_units punits
185: WHERE pop.business_group_id = g_business_group_id
186: and trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
187: and pop.organization_id = punits.organization_id
188: and (pop.organization_id = nvl(p_org_pos_id,pop.organization_id) and org_pos_fl = 'O'

Line 223: per_organization_units punits

219: pop.BUSINESS_GROUP_ID,
220: punits.name ORGANIZATION_NAME,
221: pop.availability_status_id
222: from hr_positions_f pop,
223: per_organization_units punits
224: WHERE pop.business_group_id = g_business_group_id
225: and pop.position_id in
226: (
227: SELECT position_id POSITION_ID

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

2221: B.NAME ORGANIZATION_NAME,
2222: */
2223: EMPLOYEE_ASSIGNMENT_ID,
2224: PAY_RATE_DETERMINANT
2225: from ghr_pa_requests /*, per_organization_units B*/
2226: WHERE person_id = p_person_id
2227: and effective_DATE = p_effective_DATE
2228: -- Added by Dinkar for reports
2229: and substr(request_NUMBER,(instr(request_NUMBER,'-')+1)) = to_char(p_mass_realignment_id)

Line 3071: from per_organization_units

3067: FUNCTION get_organization_name (p_org_id in NUMBER) RETURN VARCHAR2 IS
3068:
3069: CURSOR MRE_ORG_CUR (ORG_id IN NUMBER) IS
3070: SELECT name, organization_id
3071: from per_organization_units
3072: WHERE internal_external_flag = 'INT'
3073: and trunc(sysDATE) between DATE_from and nvl(DATE_to,trunc(sysDATE+1))
3074: and organization_id = org_id;
3075: