DBA Data[Home] [Help]

APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 85: ,hr_organization_units hou

81: ,substr(hoi2.org_information18,1,20) || ' ' ||hoi2.org_information20 contact_telnum_and_email
82: from
83: hr_organization_information hoi1
84: ,hr_locations_all cloc
85: ,hr_organization_units hou
86: ,hr_organization_information hoi2
87: where
88: hoi1.organization_id = l_parent_org_id
89: and hoi1.org_information_context = 'VETS_Spec'