DBA Data[Home] [Help]

APPS.HR_KW_VALIDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 926: FROM HR_ORGANIZATION_INFORMATION

922: BEGIN
923: l_organization_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
924: SELECT Org_Information1
925: INTO l_local_nationality
926: FROM HR_ORGANIZATION_INFORMATION
927: WHERE ORG_INFORMATION_CONTEXT = 'KW_BG_DETAILS'
928: AND ORGANIZATION_ID = l_organization_id;
929: EXCEPTION
930: WHEN no_data_found THEN