VIEW: APPS.BENBV_PL_REGN_V

Source

View Text - Preformatted

SELECT EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, HGHLY_COMPD_DET_RL, KEY_EE_DET_RL, CNTR_NNDSCRN_RL, CVG_NNDSCRN_RL, FIVE_PCT_OWNR_RL, /* descriptive flexfield */ '_DF:BEN:BEN_PL_REGN_F:PRG', /* codes */ PRG.REGY_PL_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_REGY_PL_TYP',PRG.REGY_PL_TYP_CD), /* id columns */ PL_REGN_ID, BUSINESS_GROUP_ID, REGN_ID, RPTG_GRP_ID, PL_ID, /* who columns */ PRG.LAST_UPDATE_DATE, PRG.LAST_UPDATED_BY, PRG.CREATED_BY, PRG.CREATION_DATE FROM BEN_PL_REGN_F PRG WHERE PRG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PRG.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, HGHLY_COMPD_DET_RL
, KEY_EE_DET_RL
, CNTR_NNDSCRN_RL
, CVG_NNDSCRN_RL
, FIVE_PCT_OWNR_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_REGN_F:PRG'
, /* CODES */ PRG.REGY_PL_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_REGY_PL_TYP'
, PRG.REGY_PL_TYP_CD)
, /* ID COLUMNS */ PL_REGN_ID
, BUSINESS_GROUP_ID
, REGN_ID
, RPTG_GRP_ID
, PL_ID
, /* WHO COLUMNS */ PRG.LAST_UPDATE_DATE
, PRG.LAST_UPDATED_BY
, PRG.CREATED_BY
, PRG.CREATION_DATE
FROM BEN_PL_REGN_F PRG
WHERE PRG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRG.BUSINESS_GROUP_ID) WITH READ ONLY