APPS.HR_SUPERVISOR_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 122: FROM hr_organization_information cost_center

118: ,pap.business_group_id,0,1
119: )
120: ),0,'Y','N'
121: ) has_update_access
122: FROM hr_organization_information cost_center
123: ,per_all_people_f pap, hr_all_organization_units hao
124: WHERE cost_center.ORG_INFORMATION2 = to_char(pap.person_id)
125: AND cost_center.org_information_context = 'Organization Name Alias'
126: AND pap.person_id = ln_person_id

Line 146: AND exists (select 'e' from hr_organization_information class, hr_org_info_types_by_class ctype

142: AND v.name = 'P_ORGANIZATION_ID'
143: AND v.number_value = hao.organization_id
144: )
145: and rownum < 2)
146: AND exists (select 'e' from hr_organization_information class, hr_org_info_types_by_class ctype
147: where ctype.org_information_type = 'Organization Name Alias'
148: and ctype.org_classification = class.org_information1
149: and class.org_information_context = 'CLASS'
150: and class.org_information2 = 'Y'

Line 156: from hr_organization_information oi

152: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
153: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
154: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
155: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
156: from hr_organization_information oi
157: where oi.org_information_context = 'Organization Name Alias'
158: and oi.organization_id = cost_center.organization_id))); -- 2476134
159:
160: -- NOTE: We need to use the primary assignment because we're trying to