APPS.HR_CN_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 45: FROM hr_organization_information hoi

41: ) return varchar2 as
42:
43: cursor cn_name_info is
44: SELECT hoi.org_information1
45: FROM hr_organization_information hoi
46: WHERE hoi.org_information_context = 'PER_CN_NAME_INFO'
47: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
48:
49: l_full_name VARCHAR2(240);