Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTL_MO_RT_PRTN_VAL_D |
SELECT PPV.ROWID ROW_ID
, PPV.PRTL_MO_RT_PRTN_VAL_ID
, PPV.EFFECTIVE_END_DATE
, PPV.EFFECTIVE_START_DATE
, ACTY_BASE_RT.NAME
, RNDG_RL.FORMULA_NAME
, RNDG.MEANING
, PPV.TO_DY_MO_NUM
, PPV.FROM_DY_MO_NUM
, PPV.PCT_VAL
, PPV.PMRPV_ATTRIBUTE_CATEGORY
, PPV.PMRPV_ATTRIBUTE1
, PPV.PMRPV_ATTRIBUTE2
, PPV.PMRPV_ATTRIBUTE3
, PPV.PMRPV_ATTRIBUTE4
, PPV.PMRPV_ATTRIBUTE5
, PPV.PMRPV_ATTRIBUTE6
, PPV.PMRPV_ATTRIBUTE7
, PPV.PMRPV_ATTRIBUTE8
, PPV.PMRPV_ATTRIBUTE9
, PPV.PMRPV_ATTRIBUTE10
, PPV.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PRTL_MO_RT_PRTN_VAL_F PPV
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS RNDG
, FF_FORMULAS_F RNDG_RL
WHERE FUSER.USER_ID (+)= PPV.LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= PPV.ACTY_BASE_RT_ID
AND RNDG.LOOKUP_CODE (+)= PPV.RNDG_CD
AND RNDG.LOOKUP_TYPE (+)= 'BEN_RNDG'
AND RNDG_RL.FORMULA_ID (+)= PPV.RNDG_RL
AND PPV.EFFECTIVE_START_DATE BETWEEN RNDG_RL.EFFECTIVE_START_DATE(+)
AND RNDG_RL.EFFECTIVE_END_DATE(+)