VIEW: APPS.BEN_PL_BNF_CTFN_PRVDD_D

Source

View Text - Preformatted

SELECT PL_BNF_CTFN_PRVDD.PL_BNF_CTFN_PRVDD_ID , PL_BNF_CTFN_PRVDD.EFFECTIVE_START_DATE , PL_BNF_CTFN_PRVDD.EFFECTIVE_END_DATE , BNF_CTFN_TYP.MEANING BNF_CTFN_TYP_MEANING , PL_BNF_CTFN_PRVDD.BNF_CTFN_RECD_DT , BNF_CTFN_RQD.MEANING BNF_CTFN_RQD_MEANING , PL_BNF_CTFN_PRVDD.LAST_UPDATE_DATE , fuser.user_name last_updated_by from fnd_user_view fuser , ben_pl_bnf_f pbn , ben_per_in_ler pil ,BEN_PL_BNF_CTFN_PRVDD_F PL_BNF_CTFN_PRVDD ,hr_lookups BNF_CTFN_TYP ,hr_lookups BNF_CTFN_RQD WHERE fuser.user_id (+)= PL_BNF_CTFN_PRVDD.last_updated_by and BNF_CTFN_TYP.lookup_code (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_TYP_CD and BNF_CTFN_TYP.lookup_type (+)= 'BEN_BNF_CTFN_TYP' and BNF_CTFN_RQD.lookup_code (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_RQD_FLAG and BNF_CTFN_RQD.lookup_type (+)= 'YES_NO' and pbn.pl_bnf_id=pl_bnf_ctfn_prvdd.pl_bnf_id and pbn.business_group_id+0=pl_bnf_ctfn_prvdd.business_group_id and pl_bnf_ctfn_prvdd.effective_start_date between pbn.effective_start_date and pbn.effective_end_date and pil.per_in_ler_id(+)=pbn.per_in_ler_id and pil.business_group_id(+)=pbn.business_group_id+0 and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT') or pil.per_in_ler_stat_cd is null )

View Text - HTML Formatted

SELECT PL_BNF_CTFN_PRVDD.PL_BNF_CTFN_PRVDD_ID
, PL_BNF_CTFN_PRVDD.EFFECTIVE_START_DATE
, PL_BNF_CTFN_PRVDD.EFFECTIVE_END_DATE
, BNF_CTFN_TYP.MEANING BNF_CTFN_TYP_MEANING
, PL_BNF_CTFN_PRVDD.BNF_CTFN_RECD_DT
, BNF_CTFN_RQD.MEANING BNF_CTFN_RQD_MEANING
, PL_BNF_CTFN_PRVDD.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM FND_USER_VIEW FUSER
, BEN_PL_BNF_F PBN
, BEN_PER_IN_LER PIL
, BEN_PL_BNF_CTFN_PRVDD_F PL_BNF_CTFN_PRVDD
, HR_LOOKUPS BNF_CTFN_TYP
, HR_LOOKUPS BNF_CTFN_RQD
WHERE FUSER.USER_ID (+)= PL_BNF_CTFN_PRVDD.LAST_UPDATED_BY
AND BNF_CTFN_TYP.LOOKUP_CODE (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_TYP_CD
AND BNF_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_BNF_CTFN_TYP'
AND BNF_CTFN_RQD.LOOKUP_CODE (+)= PL_BNF_CTFN_PRVDD.BNF_CTFN_RQD_FLAG
AND BNF_CTFN_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND PBN.PL_BNF_ID=PL_BNF_CTFN_PRVDD.PL_BNF_ID
AND PBN.BUSINESS_GROUP_ID+0=PL_BNF_CTFN_PRVDD.BUSINESS_GROUP_ID
AND PL_BNF_CTFN_PRVDD.EFFECTIVE_START_DATE BETWEEN PBN.EFFECTIVE_START_DATE
AND PBN.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID(+)=PBN.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PBN.BUSINESS_GROUP_ID+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )