View: HR_FR_PENSION_PRV_GRP_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_FR_PENSION_PRV_GRP_V

View Text

SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, NAME
, DATE_FROM
, DATE_TO
, INTERNAL_ADDRESS_LINE
, LOCATION_ID
, LOCATION_CODE
, CODE
, TYPE
, ENABLED
FROM HR_FR_PENSION_PROVIDERS_V UNION SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, NAME
, DATE_FROM
, DATE_TO
, INTERNAL_ADDRESS_LINE
, LOCATION_ID
, LOCATION_CODE
, NULL
, NULL
, ENABLED
FROM HR_FR_PENSION_GROUPS_V

Columns