VIEW: APPS.BENBV_PER_CM_V

Source

View Text - Preformatted

SELECT PCM.EFFECTIVE_START_DATE, PCM.EFFECTIVE_END_DATE, PCM.RQSTBL_UNTL_DT, PCM.PROGRAM_UPDATE_DATE, PCM.LF_EVT_OCRD_DT, /* descriptive flexfield */ '_DF:BEN:BEN_PER_CM_F:PCM', /* id columns */ PCM.PER_CM_ID, PCM.PERSON_ID, PCM.CM_TYP_ID, PCM.BUSINESS_GROUP_ID, PCM.REQUEST_ID, PCM.PROGRAM_APPLICATION_ID, PCM.PROGRAM_ID, PCM.LER_ID, PCM.BNF_PERSON_ID, PCM.DPNT_PERSON_ID, PCM.PRTT_ENRT_ACTN_ID, PCM.PER_IN_LER_ID, /* who columns */ PCM.LAST_UPDATE_DATE, PCM.LAST_UPDATED_BY, PCM.CREATED_BY, PCM.CREATION_DATE FROM BEN_PER_CM_F PCM WHERE PCM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCM.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PCM.EFFECTIVE_START_DATE
, PCM.EFFECTIVE_END_DATE
, PCM.RQSTBL_UNTL_DT
, PCM.PROGRAM_UPDATE_DATE
, PCM.LF_EVT_OCRD_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_CM_F:PCM'
, /* ID COLUMNS */ PCM.PER_CM_ID
, PCM.PERSON_ID
, PCM.CM_TYP_ID
, PCM.BUSINESS_GROUP_ID
, PCM.REQUEST_ID
, PCM.PROGRAM_APPLICATION_ID
, PCM.PROGRAM_ID
, PCM.LER_ID
, PCM.BNF_PERSON_ID
, PCM.DPNT_PERSON_ID
, PCM.PRTT_ENRT_ACTN_ID
, PCM.PER_IN_LER_ID
, /* WHO COLUMNS */ PCM.LAST_UPDATE_DATE
, PCM.LAST_UPDATED_BY
, PCM.CREATED_BY
, PCM.CREATION_DATE
FROM BEN_PER_CM_F PCM
WHERE PCM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCM.BUSINESS_GROUP_ID) WITH READ ONLY