BEN_PGM_F

Details

Schema: FUSION
Object owner: BEN
Object type: VIEW

Columns

Name
PGM_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE NAME PGM_PRVDS_NO_AUTO_ENRT_FLAG PGM_PRVDS_NO_DFLT_ENRT_FLAG DPNT_DSGN_LVL_CD PGM_STAT_CD IVR_IDENT PGM_TYP_CD ELIG_APLS_FLAG PRTT_CHC_UNCRS_TRTMT_FLAG PGM_PRVDS_CR_FLAG PGM_DESC PRTN_ELIG_OVRID_ALWD_FLAG PGM_USE_ALL_ASNTS_ELIG_FLAG MX_DPNT_PCT_PRTT_LF_AMT MX_SPS_PCT_PRTT_LF_AMT ACTY_REF_PERD_CD COORD_CVG_FOR_ALL_PLS_FLG ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_RL DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_RL DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_RL DPNT_DSGN_NO_CTFN_RQD_FLAG DRVBL_FCTR_DPNT_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_RL ENRT_INFO_RT_FREQ_CD RT_STRT_DT_CD RT_STRT_DT_RL RT_END_DT_CD RT_END_DT_RL PGM_GRP_CD PGM_UOM DRVBL_FCTR_APLS_RTS_FLAG TRK_INELIG_PER_FLAG ENRT_CD ENRT_MTHD_CD AUTO_ENRT_MTHD_RL ENRT_RL ALWS_UNRSTRCTD_ENRT_FLAG BUSINESS_GROUP_ID PGM_ATTRIBUTE_CATEGORY PGM_ATTRIBUTE1 PGM_ATTRIBUTE2 PGM_ATTRIBUTE3 PGM_ATTRIBUTE4 PGM_ATTRIBUTE5 PGM_ATTRIBUTE6 PGM_ATTRIBUTE7 PGM_ATTRIBUTE8 PGM_ATTRIBUTE9 PGM_ATTRIBUTE10 PGM_ATTRIBUTE11 PGM_ATTRIBUTE12 PGM_ATTRIBUTE13 PGM_ATTRIBUTE14 PGM_ATTRIBUTE15 PGM_ATTRIBUTE16 PGM_ATTRIBUTE17 PGM_ATTRIBUTE18 PGM_ATTRIBUTE19 PGM_ATTRIBUTE20 PGM_ATTRIBUTE21 PGM_ATTRIBUTE22 PGM_ATTRIBUTE23 PGM_ATTRIBUTE24 PGM_ATTRIBUTE25 PGM_ATTRIBUTE26 PGM_ATTRIBUTE27 PGM_ATTRIBUTE28 PGM_ATTRIBUTE29 PGM_ATTRIBUTE30 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER USES_ALL_ASMTS_FOR_RTS_FLAG URL_REF_NAME POE_LVL_CD VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_RL PER_CVRD_CD SHORT_CODE SHORT_NAME DFLT_ELEMENT_TYPE_ID DFLT_INPUT_VALUE_ID DFLT_PGM_FLAG DFLT_STEP_CD DFLT_STEP_RL SCORES_CALC_MTHD_CD SCORES_CALC_RL UPDATE_SALARY_CD USE_MULTI_PAY_RATES_FLAG USE_PROG_POINTS_FLAG USE_SCORES_CD SALARY_CALC_MTHD_CD SALARY_CALC_MTHD_RL GSP_ALLOW_OVERRIDE_FLAG USE_VARIABLE_RATES_FLAG LEGISLATION_CODE LEGISLATION_SUBGROUP GLOBAL_FLAG PGM_ATTRIBUTE_NUMBER1 PGM_ATTRIBUTE_NUMBER2 PGM_ATTRIBUTE_NUMBER3 PGM_ATTRIBUTE_NUMBER4 PGM_ATTRIBUTE_NUMBER5 PGM_ATTRIBUTE_NUMBER6 PGM_ATTRIBUTE_NUMBER7 PGM_ATTRIBUTE_NUMBER8 PGM_ATTRIBUTE_NUMBER9 PGM_ATTRIBUTE_NUMBER10 PGM_ATTRIBUTE_NUMBER11 PGM_ATTRIBUTE_NUMBER12 PGM_ATTRIBUTE_NUMBER13 PGM_ATTRIBUTE_NUMBER14 PGM_ATTRIBUTE_NUMBER15 PGM_ATTRIBUTE_NUMBER16 PGM_ATTRIBUTE_NUMBER17 PGM_ATTRIBUTE_NUMBER18 PGM_ATTRIBUTE_NUMBER19 PGM_ATTRIBUTE_NUMBER20 PGM_ATTRIBUTE_DATE1 PGM_ATTRIBUTE_DATE2 PGM_ATTRIBUTE_DATE3 PGM_ATTRIBUTE_DATE4 PGM_ATTRIBUTE_DATE5 PGM_ATTRIBUTE_DATE6 PGM_ATTRIBUTE_DATE7 PGM_ATTRIBUTE_DATE8 PGM_ATTRIBUTE_DATE9 PGM_ATTRIBUTE_DATE10 PGM_ATTRIBUTE_DATE11 PGM_ATTRIBUTE_DATE12 PGM_ATTRIBUTE_DATE13 PGM_ATTRIBUTE_DATE14 PGM_ATTRIBUTE_DATE15 CONFIG_ID_1 CONFIG_ID_2 CONFIG_ID_3 CONFIG_ID_4 CONFIG_ID_5 CONFIG_NUM_1 CONFIG_NUM_2 CONFIG_NUM_3 CONFIG_NUM_4 CONFIG_NUM_5 CONFIG_CHAR_1 CONFIG_CHAR_2 CONFIG_CHAR_3 CONFIG_CHAR_4 CONFIG_CHAR_5 CONFIG_DATE_1 CONFIG_DATE_2 CONFIG_DATE_3 CONFIG_DATE_4 CONFIG_DATE_5

Name

PGM_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

NAME

PGM_PRVDS_NO_AUTO_ENRT_FLAG

PGM_PRVDS_NO_DFLT_ENRT_FLAG

DPNT_DSGN_LVL_CD

PGM_STAT_CD

IVR_IDENT

PGM_TYP_CD

ELIG_APLS_FLAG

PRTT_CHC_UNCRS_TRTMT_FLAG

PGM_PRVDS_CR_FLAG

PGM_DESC

PRTN_ELIG_OVRID_ALWD_FLAG

PGM_USE_ALL_ASNTS_ELIG_FLAG

MX_DPNT_PCT_PRTT_LF_AMT

MX_SPS_PCT_PRTT_LF_AMT

ACTY_REF_PERD_CD

COORD_CVG_FOR_ALL_PLS_FLG

ENRT_CVG_END_DT_CD

ENRT_CVG_END_DT_RL

DPNT_CVG_END_DT_CD

DPNT_CVG_END_DT_RL

DPNT_CVG_STRT_DT_CD

DPNT_CVG_STRT_DT_RL

DPNT_DSGN_NO_CTFN_RQD_FLAG

DRVBL_FCTR_DPNT_ELIG_FLAG

DRVBL_FCTR_PRTN_ELIG_FLAG

ENRT_CVG_STRT_DT_CD

ENRT_CVG_STRT_DT_RL

ENRT_INFO_RT_FREQ_CD

RT_STRT_DT_CD

RT_STRT_DT_RL

RT_END_DT_CD

RT_END_DT_RL

PGM_GRP_CD

PGM_UOM

DRVBL_FCTR_APLS_RTS_FLAG

TRK_INELIG_PER_FLAG

ENRT_CD

ENRT_MTHD_CD

AUTO_ENRT_MTHD_RL

ENRT_RL

ALWS_UNRSTRCTD_ENRT_FLAG

BUSINESS_GROUP_ID

PGM_ATTRIBUTE_CATEGORY

PGM_ATTRIBUTE1

PGM_ATTRIBUTE2

PGM_ATTRIBUTE3

PGM_ATTRIBUTE4

PGM_ATTRIBUTE5

PGM_ATTRIBUTE6

PGM_ATTRIBUTE7

PGM_ATTRIBUTE8

PGM_ATTRIBUTE9

PGM_ATTRIBUTE10

PGM_ATTRIBUTE11

PGM_ATTRIBUTE12

PGM_ATTRIBUTE13

PGM_ATTRIBUTE14

PGM_ATTRIBUTE15

PGM_ATTRIBUTE16

PGM_ATTRIBUTE17

PGM_ATTRIBUTE18

PGM_ATTRIBUTE19

PGM_ATTRIBUTE20

PGM_ATTRIBUTE21

PGM_ATTRIBUTE22

PGM_ATTRIBUTE23

PGM_ATTRIBUTE24

PGM_ATTRIBUTE25

PGM_ATTRIBUTE26

PGM_ATTRIBUTE27

PGM_ATTRIBUTE28

PGM_ATTRIBUTE29

PGM_ATTRIBUTE30

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

USES_ALL_ASMTS_FOR_RTS_FLAG

URL_REF_NAME

POE_LVL_CD

VRFY_FMLY_MMBR_CD

VRFY_FMLY_MMBR_RL

PER_CVRD_CD

SHORT_CODE

SHORT_NAME

DFLT_ELEMENT_TYPE_ID

DFLT_INPUT_VALUE_ID

DFLT_PGM_FLAG

DFLT_STEP_CD

DFLT_STEP_RL

SCORES_CALC_MTHD_CD

SCORES_CALC_RL

UPDATE_SALARY_CD

USE_MULTI_PAY_RATES_FLAG

USE_PROG_POINTS_FLAG

USE_SCORES_CD

SALARY_CALC_MTHD_CD

SALARY_CALC_MTHD_RL

GSP_ALLOW_OVERRIDE_FLAG

USE_VARIABLE_RATES_FLAG

LEGISLATION_CODE

LEGISLATION_SUBGROUP

GLOBAL_FLAG

PGM_ATTRIBUTE_NUMBER1

PGM_ATTRIBUTE_NUMBER2

PGM_ATTRIBUTE_NUMBER3

PGM_ATTRIBUTE_NUMBER4

PGM_ATTRIBUTE_NUMBER5

PGM_ATTRIBUTE_NUMBER6

PGM_ATTRIBUTE_NUMBER7

PGM_ATTRIBUTE_NUMBER8

PGM_ATTRIBUTE_NUMBER9

PGM_ATTRIBUTE_NUMBER10

PGM_ATTRIBUTE_NUMBER11

PGM_ATTRIBUTE_NUMBER12

PGM_ATTRIBUTE_NUMBER13

PGM_ATTRIBUTE_NUMBER14

PGM_ATTRIBUTE_NUMBER15

PGM_ATTRIBUTE_NUMBER16

PGM_ATTRIBUTE_NUMBER17

PGM_ATTRIBUTE_NUMBER18

PGM_ATTRIBUTE_NUMBER19

PGM_ATTRIBUTE_NUMBER20

PGM_ATTRIBUTE_DATE1

PGM_ATTRIBUTE_DATE2

PGM_ATTRIBUTE_DATE3

PGM_ATTRIBUTE_DATE4

PGM_ATTRIBUTE_DATE5

PGM_ATTRIBUTE_DATE6

PGM_ATTRIBUTE_DATE7

PGM_ATTRIBUTE_DATE8

PGM_ATTRIBUTE_DATE9

PGM_ATTRIBUTE_DATE10

PGM_ATTRIBUTE_DATE11

PGM_ATTRIBUTE_DATE12

PGM_ATTRIBUTE_DATE13

PGM_ATTRIBUTE_DATE14

PGM_ATTRIBUTE_DATE15

CONFIG_ID_1

CONFIG_ID_2

CONFIG_ID_3

CONFIG_ID_4

CONFIG_ID_5

CONFIG_NUM_1

CONFIG_NUM_2

CONFIG_NUM_3

CONFIG_NUM_4

CONFIG_NUM_5

CONFIG_CHAR_1

CONFIG_CHAR_2

CONFIG_CHAR_3

CONFIG_CHAR_4

CONFIG_CHAR_5

CONFIG_DATE_1

CONFIG_DATE_2

CONFIG_DATE_3

CONFIG_DATE_4

CONFIG_DATE_5

Query

SQL_Statement
SELECT PGM.PGM_ID, PGM.EFFECTIVE_START_DATE, PGM.EFFECTIVE_END_DATE, NVL(TL.NAME, PGM.NAME) NAME, PGM.PGM_PRVDS_NO_AUTO_ENRT_FLAG, PGM.PGM_PRVDS_NO_DFLT_ENRT_FLAG, PGM.DPNT_DSGN_LVL_CD, PGM.PGM_STAT_CD, PGM.IVR_IDENT, PGM.PGM_TYP_CD, PGM.ELIG_APLS_FLAG, PGM.PRTT_CHC_UNCRS_TRTMT_FLAG, PGM.PGM_PRVDS_CR_FLAG, PGM.PGM_DESC, PGM.PRTN_ELIG_OVRID_ALWD_FLAG, PGM.PGM_USE_ALL_ASNTS_ELIG_FLAG, PGM.MX_DPNT_PCT_PRTT_LF_AMT, PGM.MX_SPS_PCT_PRTT_LF_AMT, PGM.ACTY_REF_PERD_CD, PGM.COORD_CVG_FOR_ALL_PLS_FLG, PGM.ENRT_CVG_END_DT_CD, PGM.ENRT_CVG_END_DT_RL, PGM.DPNT_CVG_END_DT_CD, PGM.DPNT_CVG_END_DT_RL, PGM.DPNT_CVG_STRT_DT_CD, PGM.DPNT_CVG_STRT_DT_RL, PGM.DPNT_DSGN_NO_CTFN_RQD_FLAG, PGM.DRVBL_FCTR_DPNT_ELIG_FLAG, PGM.DRVBL_FCTR_PRTN_ELIG_FLAG, PGM.ENRT_CVG_STRT_DT_CD, PGM.ENRT_CVG_STRT_DT_RL, PGM.ENRT_INFO_RT_FREQ_CD, PGM.RT_STRT_DT_CD, PGM.RT_STRT_DT_RL, PGM.RT_END_DT_CD, PGM.RT_END_DT_RL, PGM.PGM_GRP_CD, PGM.PGM_UOM, PGM.DRVBL_FCTR_APLS_RTS_FLAG, PGM.TRK_INELIG_PER_FLAG, PGM.ENRT_CD, PGM.ENRT_MTHD_CD, PGM.AUTO_ENRT_MTHD_RL, PGM.ENRT_RL, PGM.ALWS_UNRSTRCTD_ENRT_FLAG, PGM.BUSINESS_GROUP_ID, PGM.PGM_ATTRIBUTE_CATEGORY, PGM.PGM_ATTRIBUTE1, PGM.PGM_ATTRIBUTE2, PGM.PGM_ATTRIBUTE3, PGM.PGM_ATTRIBUTE4, PGM.PGM_ATTRIBUTE5, PGM.PGM_ATTRIBUTE6, PGM.PGM_ATTRIBUTE7, PGM.PGM_ATTRIBUTE8, PGM.PGM_ATTRIBUTE9, PGM.PGM_ATTRIBUTE10, PGM.PGM_ATTRIBUTE11, PGM.PGM_ATTRIBUTE12, PGM.PGM_ATTRIBUTE13, PGM.PGM_ATTRIBUTE14, PGM.PGM_ATTRIBUTE15, PGM.PGM_ATTRIBUTE16, PGM.PGM_ATTRIBUTE17, PGM.PGM_ATTRIBUTE18, PGM.PGM_ATTRIBUTE19, PGM.PGM_ATTRIBUTE20, PGM.PGM_ATTRIBUTE21, PGM.PGM_ATTRIBUTE22, PGM.PGM_ATTRIBUTE23, PGM.PGM_ATTRIBUTE24, PGM.PGM_ATTRIBUTE25, PGM.PGM_ATTRIBUTE26, PGM.PGM_ATTRIBUTE27, PGM.PGM_ATTRIBUTE28, PGM.PGM_ATTRIBUTE29, PGM.PGM_ATTRIBUTE30, PGM.LAST_UPDATE_DATE, PGM.LAST_UPDATED_BY, PGM.LAST_UPDATE_LOGIN, PGM.CREATED_BY, PGM.CREATION_DATE, PGM.OBJECT_VERSION_NUMBER, PGM.USES_ALL_ASMTS_FOR_RTS_FLAG, PGM.URL_REF_NAME, PGM.POE_LVL_CD, PGM.VRFY_FMLY_MMBR_CD, PGM.VRFY_FMLY_MMBR_RL, PGM.PER_CVRD_CD, PGM.SHORT_CODE, PGM.SHORT_NAME, PGM.DFLT_ELEMENT_TYPE_ID, PGM.DFLT_INPUT_VALUE_ID, PGM.DFLT_PGM_FLAG, PGM.DFLT_STEP_CD, PGM.DFLT_STEP_RL, PGM.SCORES_CALC_MTHD_CD, PGM.SCORES_CALC_RL, PGM.UPDATE_SALARY_CD, PGM.USE_MULTI_PAY_RATES_FLAG, PGM.USE_PROG_POINTS_FLAG, PGM.USE_SCORES_CD, PGM.SALARY_CALC_MTHD_CD, PGM.SALARY_CALC_MTHD_RL, PGM.GSP_ALLOW_OVERRIDE_FLAG, PGM.USE_VARIABLE_RATES_FLAG, PGM.LEGISLATION_CODE, PGM.LEGISLATION_SUBGROUP, PGM.GLOBAL_FLAG, PGM.PGM_ATTRIBUTE_NUMBER1, PGM.PGM_ATTRIBUTE_NUMBER2, PGM.PGM_ATTRIBUTE_NUMBER3, PGM.PGM_ATTRIBUTE_NUMBER4, PGM.PGM_ATTRIBUTE_NUMBER5, PGM.PGM_ATTRIBUTE_NUMBER6, PGM.PGM_ATTRIBUTE_NUMBER7, PGM.PGM_ATTRIBUTE_NUMBER8, PGM.PGM_ATTRIBUTE_NUMBER9, PGM.PGM_ATTRIBUTE_NUMBER10, PGM.PGM_ATTRIBUTE_NUMBER11, PGM.PGM_ATTRIBUTE_NUMBER12, PGM.PGM_ATTRIBUTE_NUMBER13, PGM.PGM_ATTRIBUTE_NUMBER14, PGM.PGM_ATTRIBUTE_NUMBER15, PGM.PGM_ATTRIBUTE_NUMBER16, PGM.PGM_ATTRIBUTE_NUMBER17, PGM.PGM_ATTRIBUTE_NUMBER18, PGM.PGM_ATTRIBUTE_NUMBER19, PGM.PGM_ATTRIBUTE_NUMBER20, PGM.PGM_ATTRIBUTE_DATE1, PGM.PGM_ATTRIBUTE_DATE2, PGM.PGM_ATTRIBUTE_DATE3, PGM.PGM_ATTRIBUTE_DATE4, PGM.PGM_ATTRIBUTE_DATE5, PGM.PGM_ATTRIBUTE_DATE6, PGM.PGM_ATTRIBUTE_DATE7, PGM.PGM_ATTRIBUTE_DATE8, PGM.PGM_ATTRIBUTE_DATE9, PGM.PGM_ATTRIBUTE_DATE10, PGM.PGM_ATTRIBUTE_DATE11, PGM.PGM_ATTRIBUTE_DATE12, PGM.PGM_ATTRIBUTE_DATE13, PGM.PGM_ATTRIBUTE_DATE14, PGM.PGM_ATTRIBUTE_DATE15, PGM.CONFIG_ID_1, PGM.CONFIG_ID_2, PGM.CONFIG_ID_3, PGM.CONFIG_ID_4, PGM.CONFIG_ID_5, PGM.CONFIG_NUM_1, PGM.CONFIG_NUM_2, PGM.CONFIG_NUM_3, PGM.CONFIG_NUM_4, PGM.CONFIG_NUM_5, PGM.CONFIG_CHAR_1, PGM.CONFIG_CHAR_2, PGM.CONFIG_CHAR_3, PGM.CONFIG_CHAR_4, PGM.CONFIG_CHAR_5, PGM.CONFIG_DATE_1, PGM.CONFIG_DATE_2, PGM.CONFIG_DATE_3, PGM.CONFIG_DATE_4, PGM.CONFIG_DATE_5 FROM BEN_PGM_F PGM, BEN_PGM_F_TL TL WHERE PGM.PGM_ID = TL.PGM_ID(+) AND PGM.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE(+) AND TL.LANGUAGE(+) = USERENV('LANG')

SQL_Statement

SELECT

PGM.PGM_ID,

PGM.EFFECTIVE_START_DATE,

PGM.EFFECTIVE_END_DATE,

NVL(TL.NAME, PGM.NAME) NAME,

PGM.PGM_PRVDS_NO_AUTO_ENRT_FLAG,

PGM.PGM_PRVDS_NO_DFLT_ENRT_FLAG,

PGM.DPNT_DSGN_LVL_CD,

PGM.PGM_STAT_CD,

PGM.IVR_IDENT,

PGM.PGM_TYP_CD,

PGM.ELIG_APLS_FLAG,

PGM.PRTT_CHC_UNCRS_TRTMT_FLAG,

PGM.PGM_PRVDS_CR_FLAG,

PGM.PGM_DESC,

PGM.PRTN_ELIG_OVRID_ALWD_FLAG,

PGM.PGM_USE_ALL_ASNTS_ELIG_FLAG,

PGM.MX_DPNT_PCT_PRTT_LF_AMT,

PGM.MX_SPS_PCT_PRTT_LF_AMT,

PGM.ACTY_REF_PERD_CD,

PGM.COORD_CVG_FOR_ALL_PLS_FLG,

PGM.ENRT_CVG_END_DT_CD,

PGM.ENRT_CVG_END_DT_RL,

PGM.DPNT_CVG_END_DT_CD,

PGM.DPNT_CVG_END_DT_RL,

PGM.DPNT_CVG_STRT_DT_CD,

PGM.DPNT_CVG_STRT_DT_RL,

PGM.DPNT_DSGN_NO_CTFN_RQD_FLAG,

PGM.DRVBL_FCTR_DPNT_ELIG_FLAG,

PGM.DRVBL_FCTR_PRTN_ELIG_FLAG,

PGM.ENRT_CVG_STRT_DT_CD,

PGM.ENRT_CVG_STRT_DT_RL,

PGM.ENRT_INFO_RT_FREQ_CD,

PGM.RT_STRT_DT_CD,

PGM.RT_STRT_DT_RL,

PGM.RT_END_DT_CD,

PGM.RT_END_DT_RL,

PGM.PGM_GRP_CD,

PGM.PGM_UOM,

PGM.DRVBL_FCTR_APLS_RTS_FLAG,

PGM.TRK_INELIG_PER_FLAG,

PGM.ENRT_CD,

PGM.ENRT_MTHD_CD,

PGM.AUTO_ENRT_MTHD_RL,

PGM.ENRT_RL,

PGM.ALWS_UNRSTRCTD_ENRT_FLAG,

PGM.BUSINESS_GROUP_ID,

PGM.PGM_ATTRIBUTE_CATEGORY,

PGM.PGM_ATTRIBUTE1,

PGM.PGM_ATTRIBUTE2,

PGM.PGM_ATTRIBUTE3,

PGM.PGM_ATTRIBUTE4,

PGM.PGM_ATTRIBUTE5,

PGM.PGM_ATTRIBUTE6,

PGM.PGM_ATTRIBUTE7,

PGM.PGM_ATTRIBUTE8,

PGM.PGM_ATTRIBUTE9,

PGM.PGM_ATTRIBUTE10,

PGM.PGM_ATTRIBUTE11,

PGM.PGM_ATTRIBUTE12,

PGM.PGM_ATTRIBUTE13,

PGM.PGM_ATTRIBUTE14,

PGM.PGM_ATTRIBUTE15,

PGM.PGM_ATTRIBUTE16,

PGM.PGM_ATTRIBUTE17,

PGM.PGM_ATTRIBUTE18,

PGM.PGM_ATTRIBUTE19,

PGM.PGM_ATTRIBUTE20,

PGM.PGM_ATTRIBUTE21,

PGM.PGM_ATTRIBUTE22,

PGM.PGM_ATTRIBUTE23,

PGM.PGM_ATTRIBUTE24,

PGM.PGM_ATTRIBUTE25,

PGM.PGM_ATTRIBUTE26,

PGM.PGM_ATTRIBUTE27,

PGM.PGM_ATTRIBUTE28,

PGM.PGM_ATTRIBUTE29,

PGM.PGM_ATTRIBUTE30,

PGM.LAST_UPDATE_DATE,

PGM.LAST_UPDATED_BY,

PGM.LAST_UPDATE_LOGIN,

PGM.CREATED_BY,

PGM.CREATION_DATE,

PGM.OBJECT_VERSION_NUMBER,

PGM.USES_ALL_ASMTS_FOR_RTS_FLAG,

PGM.URL_REF_NAME,

PGM.POE_LVL_CD,

PGM.VRFY_FMLY_MMBR_CD,

PGM.VRFY_FMLY_MMBR_RL,

PGM.PER_CVRD_CD,

PGM.SHORT_CODE,

PGM.SHORT_NAME,

PGM.DFLT_ELEMENT_TYPE_ID,

PGM.DFLT_INPUT_VALUE_ID,

PGM.DFLT_PGM_FLAG,

PGM.DFLT_STEP_CD,

PGM.DFLT_STEP_RL,

PGM.SCORES_CALC_MTHD_CD,

PGM.SCORES_CALC_RL,

PGM.UPDATE_SALARY_CD,

PGM.USE_MULTI_PAY_RATES_FLAG,

PGM.USE_PROG_POINTS_FLAG,

PGM.USE_SCORES_CD,

PGM.SALARY_CALC_MTHD_CD,

PGM.SALARY_CALC_MTHD_RL,

PGM.GSP_ALLOW_OVERRIDE_FLAG,

PGM.USE_VARIABLE_RATES_FLAG,

PGM.LEGISLATION_CODE,

PGM.LEGISLATION_SUBGROUP,

PGM.GLOBAL_FLAG,

PGM.PGM_ATTRIBUTE_NUMBER1,

PGM.PGM_ATTRIBUTE_NUMBER2,

PGM.PGM_ATTRIBUTE_NUMBER3,

PGM.PGM_ATTRIBUTE_NUMBER4,

PGM.PGM_ATTRIBUTE_NUMBER5,

PGM.PGM_ATTRIBUTE_NUMBER6,

PGM.PGM_ATTRIBUTE_NUMBER7,

PGM.PGM_ATTRIBUTE_NUMBER8,

PGM.PGM_ATTRIBUTE_NUMBER9,

PGM.PGM_ATTRIBUTE_NUMBER10,

PGM.PGM_ATTRIBUTE_NUMBER11,

PGM.PGM_ATTRIBUTE_NUMBER12,

PGM.PGM_ATTRIBUTE_NUMBER13,

PGM.PGM_ATTRIBUTE_NUMBER14,

PGM.PGM_ATTRIBUTE_NUMBER15,

PGM.PGM_ATTRIBUTE_NUMBER16,

PGM.PGM_ATTRIBUTE_NUMBER17,

PGM.PGM_ATTRIBUTE_NUMBER18,

PGM.PGM_ATTRIBUTE_NUMBER19,

PGM.PGM_ATTRIBUTE_NUMBER20,

PGM.PGM_ATTRIBUTE_DATE1,

PGM.PGM_ATTRIBUTE_DATE2,

PGM.PGM_ATTRIBUTE_DATE3,

PGM.PGM_ATTRIBUTE_DATE4,

PGM.PGM_ATTRIBUTE_DATE5,

PGM.PGM_ATTRIBUTE_DATE6,

PGM.PGM_ATTRIBUTE_DATE7,

PGM.PGM_ATTRIBUTE_DATE8,

PGM.PGM_ATTRIBUTE_DATE9,

PGM.PGM_ATTRIBUTE_DATE10,

PGM.PGM_ATTRIBUTE_DATE11,

PGM.PGM_ATTRIBUTE_DATE12,

PGM.PGM_ATTRIBUTE_DATE13,

PGM.PGM_ATTRIBUTE_DATE14,

PGM.PGM_ATTRIBUTE_DATE15,

PGM.CONFIG_ID_1,

PGM.CONFIG_ID_2,

PGM.CONFIG_ID_3,

PGM.CONFIG_ID_4,

PGM.CONFIG_ID_5,

PGM.CONFIG_NUM_1,

PGM.CONFIG_NUM_2,

PGM.CONFIG_NUM_3,

PGM.CONFIG_NUM_4,

PGM.CONFIG_NUM_5,

PGM.CONFIG_CHAR_1,

PGM.CONFIG_CHAR_2,

PGM.CONFIG_CHAR_3,

PGM.CONFIG_CHAR_4,

PGM.CONFIG_CHAR_5,

PGM.CONFIG_DATE_1,

PGM.CONFIG_DATE_2,

PGM.CONFIG_DATE_3,

PGM.CONFIG_DATE_4,

PGM.CONFIG_DATE_5

FROM

BEN_PGM_F PGM,

BEN_PGM_F_TL TL

WHERE

PGM.PGM_ID = TL.PGM_ID(+) AND PGM.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE(+) AND TL.LANGUAGE(+) = USERENV('LANG')