View: BEN_POPL_ACTN_TYP_D

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

View Text

SELECT PAT.ROWID ROW_ID
, PAT.POPL_ACTN_TYP_ID
, PAT.EFFECTIVE_START_DATE
, PAT.EFFECTIVE_END_DATE
, ACTN_TYP_DUE_DT.MEANING
, ACTN_TYP_DUE_DT_RL.FORMULA_NAME
, ACTN_TYP.NAME
, PGM.NAME
, PL.NAME
, PAT.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_POPL_ACTN_TYP_F PAT
, FND_USER FUSER
, BEN_ACTN_TYP ACTN_TYP
, BEN_PGM_F PGM
, BEN_PL_F PL
, HR_LOOKUPS ACTN_TYP_DUE_DT
, FF_FORMULAS_F ACTN_TYP_DUE_DT_RL
WHERE FUSER.USER_ID (+)= PAT .LAST_UPDATED_BY
AND ACTN_TYP.ACTN_TYP_ID (+)= PAT .ACTN_TYP_ID
AND PGM.PGM_ID (+)= PAT .PGM_ID
AND PL.PL_ID (+)= PAT .PL_ID
AND ACTN_TYP_DUE_DT.LOOKUP_CODE (+)= PAT .ACTN_TYP_DUE_DT_CD
AND ACTN_TYP_DUE_DT.LOOKUP_TYPE (+)= 'BEN_ACTN_TYP_DUE_DT'
AND ACTN_TYP_DUE_DT_RL.FORMULA_ID (+)= PAT .ACTN_TYP_DUE_DT_RL
AND PAT .EFFECTIVE_START_DATE BETWEEN ACTN_TYP_DUE_DT_RL.EFFECTIVE_START_DATE
AND ACTN_TYP_DUE_DT_RL.EFFECTIVE_END_DATE

Columns