VIEW: APPS.BENBV_PRMRY_CARE_PRVDR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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