APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 150: ,hr_organization_information hoi1

146: ,org.name
147: ,hoi1.org_information2
148: ,org.location_id
149: FROM hr_all_organization_units org
150: ,hr_organization_information hoi1
151: WHERE org.organization_id = p_legal_employer_id
152: AND hoi1.organization_id (+) = org.organization_id
153: AND hoi1.org_information_context (+) = 'SE_LEGAL_EMPLOYER_DETAILS';
154:

Line 166: FROM hr_organization_information hoi

162:
163: CURSOR csr_le_contact_person
164: (p_legal_employer_id IN NUMBER) IS
165: SELECT substr(hoi.org_information3,1,25) contact_person
166: FROM hr_organization_information hoi
167: WHERE hoi.organization_id = p_legal_employer_id
168: AND hoi.org_information_context = 'SE_ORG_CONTACT_DETAILS';
169:
170: --

Line 412: hr_organization_information hoi_le,

408: hou_lu.NAME local_unit_name,
409: hoi_lu.org_information1,
410: hou_lu.location_id
411: FROM hr_all_organization_units hou_le,
412: hr_organization_information hoi_le,
413: hr_all_organization_units hou_lu,
414: hr_organization_information hoi_lu
415: WHERE hoi_le.organization_id = hou_le.organization_id
416: AND hou_le.organization_id = p_legal_employer_id

Line 414: hr_organization_information hoi_lu

410: hou_lu.location_id
411: FROM hr_all_organization_units hou_le,
412: hr_organization_information hoi_le,
413: hr_all_organization_units hou_lu,
414: hr_organization_information hoi_lu
415: WHERE hoi_le.organization_id = hou_le.organization_id
416: AND hou_le.organization_id = p_legal_employer_id
417: AND hoi_le.org_information_context = 'SE_LOCAL_UNITS'
418: AND hou_lu.organization_id = hoi_le.org_information1