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 100: per_organization_units punits

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

Line 138: per_organization_units punits

134: punits.name ORGANIZATION_NAME
135: from per_assignments_f paf,
136: per_people_f ppf,
137: per_person_types ppt,
138: per_organization_units punits
139: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
140: and
141: org_pos_fl = 'P')
142: and ppf.person_id = paf.person_id

Line 178: per_organization_units punits

174: pop.BUSINESS_GROUP_ID,
175: punits.name ORGANIZATION_NAME,
176: pop.availability_status_id
177: from hr_positions_f pop,
178: per_organization_units punits
179: WHERE pop.business_group_id = g_business_group_id
180: and trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
181: and pop.organization_id = punits.organization_id
182: and (pop.organization_id = nvl(p_org_pos_id,pop.organization_id) and org_pos_fl = 'O'

Line 217: per_organization_units punits

213: pop.BUSINESS_GROUP_ID,
214: punits.name ORGANIZATION_NAME,
215: pop.availability_status_id
216: from hr_positions_f pop,
217: per_organization_units punits
218: WHERE pop.business_group_id = g_business_group_id
219: and pop.position_id in
220: (
221: SELECT position_id POSITION_ID

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

2073: B.NAME ORGANIZATION_NAME,
2074: */
2075: EMPLOYEE_ASSIGNMENT_ID,
2076: PAY_RATE_DETERMINANT
2077: from ghr_pa_requests /*, per_organization_units B*/
2078: WHERE person_id = p_person_id
2079: and effective_DATE = p_effective_DATE
2080: -- Added by Dinkar for reports
2081: and substr(request_NUMBER,(instr(request_NUMBER,'-')+1)) = to_char(p_mass_realignment_id)

Line 2910: from per_organization_units

2906: FUNCTION get_organization_name (p_org_id in NUMBER) RETURN VARCHAR2 IS
2907:
2908: CURSOR MRE_ORG_CUR (ORG_id IN NUMBER) IS
2909: SELECT name, organization_id
2910: from per_organization_units
2911: WHERE internal_external_flag = 'INT'
2912: and trunc(sysDATE) between DATE_from and nvl(DATE_to,trunc(sysDATE+1))
2913: and organization_id = org_id;
2914: