VIEW: APPS.BEN_POPL_ACTN_TYP_D

Source

View Text - Preformatted

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(+) and pat.effective_start_date BETWEEN pl.effective_start_date(+) AND pl.effective_end_date(+) and pat.effective_start_date BETWEEN pgm.effective_start_date(+) AND pgm.effective_end_date(+)

View Text - HTML Formatted

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(+)
AND PAT.EFFECTIVE_START_DATE BETWEEN PL.EFFECTIVE_START_DATE(+)
AND PL.EFFECTIVE_END_DATE(+)
AND PAT.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)