345: SELECT org.org_information1,
346: org.org_information2,
347: org.org_information3,
348: org.org_information4
349: FROM hr_organization_information_v org
350: WHERE org.org_information_context = p_context
351: AND org.organization_id = p_bg_id;
352: --
353: --
587: ,hou1.name tax_office_name
588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'
594: AND hoi.org_information1 = 'HR_ORG'
595: AND hoi.organization_id = HOU.organization_id
588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'
594: AND hoi.org_information1 = 'HR_ORG'
595: AND hoi.organization_id = HOU.organization_id
596: AND hou.business_group_id = p_bus_group_id