View: BEN_PAIRD_RT_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_PAIRD_RT_D

View Text

SELECT PRD.ROWID ROW_ID
, PRD.PAIRD_RT_ID
, PRD.EFFECTIVE_START_DATE
, PRD.EFFECTIVE_END_DATE
, USE_PARNT_DED_SCHED.MEANING
, ASN_ON_CHC_OF_PARNT.MEANING
, USE_PARNT_PRTL_MO_CD.MEANING
, ALLOC_SME_AS_PARNT.MEANING
, USE_PARNT_PYMT_SCHED.MEANING
, NO_CMBND_MX_AMT_DFND.MEANING
, PRD.CMBND_MX_AMT
, PRD.CMBND_MN_AMT
, PRD.CMBND_MX_PCT_NUM
, PRD.CMBND_MN_PCT_NUM
, NO_CMBND_MN_AMT_DFND.MEANING
, NO_CMBND_MN_PCT_DFND.MEANING
, NO_CMBND_MX_PCT_DFND.MEANING
, PARNT_ACTY_BASE_RT.NAME
, CHLD_ACTY_BASE_RT.NAME
, PRD.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PAIRD_RT_F PRD
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F PARNT_ACTY_BASE_RT
, BEN_ACTY_BASE_RT_F CHLD_ACTY_BASE_RT
, HR_LOOKUPS USE_PARNT_DED_SCHED
, HR_LOOKUPS ASN_ON_CHC_OF_PARNT
, HR_LOOKUPS USE_PARNT_PRTL_MO_CD
, HR_LOOKUPS ALLOC_SME_AS_PARNT
, HR_LOOKUPS USE_PARNT_PYMT_SCHED
, HR_LOOKUPS NO_CMBND_MX_AMT_DFND
, HR_LOOKUPS NO_CMBND_MN_AMT_DFND
, HR_LOOKUPS NO_CMBND_MN_PCT_DFND
, HR_LOOKUPS NO_CMBND_MX_PCT_DFND
WHERE FUSER.USER_ID (+)= PRD .LAST_UPDATED_BY
AND PARNT_ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= PRD.PARNT_ACTY_BASE_RT_ID
AND CHLD_ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= PRD.CHLD_ACTY_BASE_RT_ID
AND USE_PARNT_PRTL_MO_CD.LOOKUP_CODE (+)= PRD.USE_PARNT_PRTL_MO_CD_FLAG
AND USE_PARNT_PRTL_MO_CD.LOOKUP_TYPE (+)= 'YES_NO'
AND USE_PARNT_DED_SCHED.LOOKUP_CODE (+)= PRD.USE_PARNT_DED_SCHED_FLAG
AND USE_PARNT_DED_SCHED.LOOKUP_TYPE (+)= 'YES_NO'
AND ASN_ON_CHC_OF_PARNT.LOOKUP_CODE (+)= PRD.ASN_ON_CHC_OF_PARNT_FLAG
AND ASN_ON_CHC_OF_PARNT.LOOKUP_TYPE (+)= 'YES_NO'
AND ALLOC_SME_AS_PARNT.LOOKUP_CODE (+)= PRD.ALLOC_SME_AS_PARNT_FLAG
AND ALLOC_SME_AS_PARNT.LOOKUP_TYPE (+)= 'YES_NO'
AND USE_PARNT_PYMT_SCHED.LOOKUP_CODE (+)= PRD.USE_PARNT_PYMT_SCHED_FLAG
AND USE_PARNT_PYMT_SCHED.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_CMBND_MX_AMT_DFND.LOOKUP_CODE (+)= PRD.NO_CMBND_MX_AMT_DFND_FLAG
AND NO_CMBND_MX_AMT_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_CMBND_MN_AMT_DFND.LOOKUP_CODE (+)= PRD.NO_CMBND_MN_AMT_DFND_FLAG
AND NO_CMBND_MN_AMT_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_CMBND_MN_PCT_DFND.LOOKUP_CODE (+)= PRD.NO_CMBND_MN_PCT_DFND_FLAG
AND NO_CMBND_MN_PCT_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_CMBND_MX_PCT_DFND.LOOKUP_CODE (+)= PRD.NO_CMBND_MX_PCT_DFND_FLAG
AND NO_CMBND_MX_PCT_DFND.LOOKUP_TYPE (+)= 'YES_NO'

Columns