Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies section or part of legislation, rule, code, or policy pertinent to the proper management of this plan or reporting group. |
Implementation/DBA Data: | APPS.BENBV_PL_REGN_V |
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