VIEW: APPS.BEN_PAIRD_RT_D

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'