VIEW: APPS.BENBV_PTNL_LER_FOR_PER_V

Source

View Text - Preformatted

SELECT PTN.LF_EVT_OCRD_DT, PTN.DTCTD_DT, PTN.PROCD_DT, PTN.UNPROCD_DT, PTN.VOIDD_DT, PTN.MNL_DT, PTN.MNLO_DT, PTN.PROGRAM_UPDATE_DATE, PTN.NTFN_DT, /* codes */ PTN.PTNL_LER_FOR_PER_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_STAT',PTN.PTNL_LER_FOR_PER_STAT_CD), PTN.PTNL_LER_FOR_PER_SRC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_SRC',PTN.PTNL_LER_FOR_PER_SRC_CD), /* id columns */ PTN.PTNL_LER_FOR_PER_ID, PTN.BUSINESS_GROUP_ID, PTN.LER_ID, PTN.PERSON_ID, PTN.ENRT_PERD_ID, PTN.REQUEST_ID, PTN.PROGRAM_APPLICATION_ID, PTN.PROGRAM_ID, PTN.CSD_BY_PTNL_LER_FOR_PER_ID, PTN.TRGR_TABLE_PK_ID, /* who columns */ PTN.LAST_UPDATE_DATE, PTN.LAST_UPDATED_BY, PTN.CREATED_BY, PTN.CREATION_DATE FROM BEN_PTNL_LER_FOR_PER PTN WHERE PTN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PTN.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PTN.LF_EVT_OCRD_DT
, PTN.DTCTD_DT
, PTN.PROCD_DT
, PTN.UNPROCD_DT
, PTN.VOIDD_DT
, PTN.MNL_DT
, PTN.MNLO_DT
, PTN.PROGRAM_UPDATE_DATE
, PTN.NTFN_DT
, /* CODES */ PTN.PTNL_LER_FOR_PER_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_STAT'
, PTN.PTNL_LER_FOR_PER_STAT_CD)
, PTN.PTNL_LER_FOR_PER_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PTNL_LER_FOR_PER_SRC'
, PTN.PTNL_LER_FOR_PER_SRC_CD)
, /* ID COLUMNS */ PTN.PTNL_LER_FOR_PER_ID
, PTN.BUSINESS_GROUP_ID
, PTN.LER_ID
, PTN.PERSON_ID
, PTN.ENRT_PERD_ID
, PTN.REQUEST_ID
, PTN.PROGRAM_APPLICATION_ID
, PTN.PROGRAM_ID
, PTN.CSD_BY_PTNL_LER_FOR_PER_ID
, PTN.TRGR_TABLE_PK_ID
, /* WHO COLUMNS */ PTN.LAST_UPDATE_DATE
, PTN.LAST_UPDATED_BY
, PTN.CREATED_BY
, PTN.CREATION_DATE
FROM BEN_PTNL_LER_FOR_PER PTN
WHERE PTN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PTN.BUSINESS_GROUP_ID) WITH READ ONLY