VIEW: APPS.BENBV_PER_IN_LER_V

Source

View Text - Preformatted

SELECT PIL.LF_EVT_OCRD_DT, PIL.PROGRAM_UPDATE_DATE, PIL.PROCD_DT, PIL.STRTD_DT, PIL.VOIDD_DT, PIL.BCKT_DT, PIL.CLSD_DT, PIL.NTFN_DT, PIL.MGR_OVRID_DT, BEN_BIS_UTILS.GET_GROUP_PL_NAME(PIL.GROUP_PL_ID, PIL.LF_EVT_OCRD_DT), /* descriptive flexfield */ '_DF:BEN:BEN_PER_IN_LER:PIL', /* codes */ PIL.PER_IN_LER_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT',PIL.PER_IN_LER_STAT_CD), PIL.PRVS_STAT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT',PIL.PRVS_STAT_CD), /* id columns */ PIL.PER_IN_LER_ID, PIL.BUSINESS_GROUP_ID, PIL.LER_ID, PIL.PERSON_ID, PIL.PTNL_LER_FOR_PER_ID, PIL.REQUEST_ID, PIL.PROGRAM_APPLICATION_ID, PIL.PROGRAM_ID, PIL.BCKT_PER_IN_LER_ID, PIL.TRGR_TABLE_PK_ID, PIL.ASSIGNMENT_ID, PIL.WS_MGR_ID, PIL.GROUP_PL_ID, PIL.MGR_OVRID_PERSON_ID, /* who columns */ PIL.LAST_UPDATE_DATE, PIL.LAST_UPDATED_BY, PIL.CREATED_BY, PIL.CREATION_DATE FROM BEN_PER_IN_LER PIL WHERE PIL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PIL.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PIL.LF_EVT_OCRD_DT
, PIL.PROGRAM_UPDATE_DATE
, PIL.PROCD_DT
, PIL.STRTD_DT
, PIL.VOIDD_DT
, PIL.BCKT_DT
, PIL.CLSD_DT
, PIL.NTFN_DT
, PIL.MGR_OVRID_DT
, BEN_BIS_UTILS.GET_GROUP_PL_NAME(PIL.GROUP_PL_ID
, PIL.LF_EVT_OCRD_DT)
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_IN_LER:PIL'
, /* CODES */ PIL.PER_IN_LER_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PIL.PER_IN_LER_STAT_CD)
, PIL.PRVS_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PER_IN_LER_STAT'
, PIL.PRVS_STAT_CD)
, /* ID COLUMNS */ PIL.PER_IN_LER_ID
, PIL.BUSINESS_GROUP_ID
, PIL.LER_ID
, PIL.PERSON_ID
, PIL.PTNL_LER_FOR_PER_ID
, PIL.REQUEST_ID
, PIL.PROGRAM_APPLICATION_ID
, PIL.PROGRAM_ID
, PIL.BCKT_PER_IN_LER_ID
, PIL.TRGR_TABLE_PK_ID
, PIL.ASSIGNMENT_ID
, PIL.WS_MGR_ID
, PIL.GROUP_PL_ID
, PIL.MGR_OVRID_PERSON_ID
, /* WHO COLUMNS */ PIL.LAST_UPDATE_DATE
, PIL.LAST_UPDATED_BY
, PIL.CREATED_BY
, PIL.CREATION_DATE
FROM BEN_PER_IN_LER PIL
WHERE PIL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PIL.BUSINESS_GROUP_ID) WITH READ ONLY