DBA Data[Home] [Help]

APPS.HR_KW_VALIDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 938: FROM HR_ORGANIZATION_INFORMATION

934: BEGIN
935: l_organization_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
936: SELECT Org_Information1
937: INTO l_local_nationality
938: FROM HR_ORGANIZATION_INFORMATION
939: WHERE ORG_INFORMATION_CONTEXT = 'KW_BG_DETAILS'
940: AND ORGANIZATION_ID = l_organization_id;
941: EXCEPTION
942: WHEN no_data_found THEN