Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the certification that may be required in order to designate a person as a dependent when dependent designation is defined at the plan level. |
Implementation/DBA Data: | APPS.BENBV_PL_DPNT_CVG_CTFN_V |
SELECT PND.EFFECTIVE_START_DATE
, PND.EFFECTIVE_END_DATE
, PND.CTFN_RQD_WHEN_RL
, PND.PROGRAM_UPDATE_DATE
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PL_DPNT_CVG_CTFN_F:PND'
, /* CODES */ PND.DPNT_CVG_CTFN_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_CTFN_TYP'
, PND.DPNT_CVG_CTFN_TYP_CD)
, PND.RLSHP_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, PND.RLSHP_TYP_CD)
, PND.PFD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.PFD_FLAG)
, PND.LACK_CTFN_SSPND_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.LACK_CTFN_SSPND_ENRT_FLAG)
, PND.RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PND.RQD_FLAG)
, /* ID COLUMNS */ PND.PL_DPNT_CVG_CTFN_ID
, PND.BUSINESS_GROUP_ID
, PND.PL_ID
, PND.REQUEST_ID
, PND.PROGRAM_APPLICATION_ID
, PND.PROGRAM_ID
, /* WHO COLUMNS */ PND.LAST_UPDATE_DATE
, PND.LAST_UPDATED_BY
, PND.CREATED_BY
, PND.CREATION_DATE
FROM BEN_PL_DPNT_CVG_CTFN_F PND
WHERE PND.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PND.BUSINESS_GROUP_ID) WITH READ ONLY