View: BENBV_PRMRY_CARE_PRVDR_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the care providers, physicians, and chiropractors, for a participant enrolled in a plan or option in plan or for a dependent covered
Implementation/DBA Data:	APPS.BENBV_PRMRY_CARE_PRVDR_V

View Text

SELECT PPR.EFFECTIVE_START_DATE
, PPR.EFFECTIVE_END_DATE
, PPR.NAME
, PPR.PROGRAM_UPDATE_DATE
, PPR.EXT_IDENT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRMRY_CARE_PRVDR:PPR'
, /* CODES */ PPR.PRMRY_CARE_PRVDR_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PCP_SPCLTY'
, PPR.PRMRY_CARE_PRVDR_TYP_CD)
, /* ID COLUMNS */ PPR.PRMRY_CARE_PRVDR_ID
, PPR.BUSINESS_GROUP_ID
, PPR.ELIG_CVRD_DPNT_ID
, PPR.PRTT_ENRT_RSLT_ID
, PPR.REQUEST_ID
, PPR.PROGRAM_APPLICATION_ID
, PPR.PROGRAM_ID
, /* WHO COLUMNS */ PPR.LAST_UPDATE_DATE
, PPR.LAST_UPDATED_BY
, PPR.CREATED_BY
, PPR.CREATION_DATE
FROM BEN_PRMRY_CARE_PRVDR_F PPR
WHERE PPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns