VIEW: APPS.BEN_PTD_LMT_D

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)