Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PTD_LMT_D |
SELECT PDL.ROWID ROW_ID
, PDL.PTD_LMT_ID
, PDL.EFFECTIVE_START_DATE
, PDL.EFFECTIVE_END_DATE
, PDL.NAME
, PDL.MX_COMP_TO_CNSDR
, PDL.MX_VAL
, PDL.MX_PCT_VAL
, PTD_LMT_CALC.FORMULA_NAME
, LMT_DET.MEANING
, COMP_LVL_FCTR.NAME
, BALANCE_TYPE.BALANCE_NAME
, PDL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PTD_LMT_F PDL
, FND_USER_VIEW FUSER
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, PAY_BALANCE_TYPES BALANCE_TYPE
, HR_LOOKUPS LMT_DET
, FF_FORMULAS_F PTD_LMT_CALC
WHERE FUSER.USER_ID (+)= PDL .LAST_UPDATED_BY
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= PDL .COMP_LVL_FCTR_ID
AND BALANCE_TYPE.BALANCE_TYPE_ID (+)= PDL .BALANCE_TYPE_ID
AND LMT_DET.LOOKUP_CODE (+)= PDL .LMT_DET_CD
AND LMT_DET.LOOKUP_TYPE (+)= 'BEN_LMT_DET'
AND PTD_LMT_CALC.FORMULA_ID (+)= PDL .PTD_LMT_CALC_RL
AND PDL .EFFECTIVE_START_DATE BETWEEN PTD_LMT_CALC.EFFECTIVE_START_DATE (+)
AND PTD_LMT_CALC.EFFECTIVE_END_DATE (+)