VIEW: APPS.BENBV_PER_CM_TRGR_V

Source

View Text - Preformatted

SELECT PCR.EFFECTIVE_START_DATE, PCR.EFFECTIVE_END_DATE, PCR.PROGRAM_UPDATE_DATE, /* descriptive flexfield */ '_DF:BEN:BEN_PER_CM_TRGR_F:PCR', /* id columns */ PCR.PER_CM_TRGR_ID, PCR.CM_TRGR_ID, PCR.BUSINESS_GROUP_ID, PCR.PER_CM_ID, PCR.REQUEST_ID, PCR.PROGRAM_APPLICATION_ID, PCR.PROGRAM_ID, /* who columns */ PCR.LAST_UPDATE_DATE, PCR.LAST_UPDATED_BY, PCR.CREATED_BY, PCR.CREATION_DATE FROM BEN_PER_CM_TRGR_F PCR WHERE PCR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PCR.EFFECTIVE_START_DATE
, PCR.EFFECTIVE_END_DATE
, PCR.PROGRAM_UPDATE_DATE
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PER_CM_TRGR_F:PCR'
, /* ID COLUMNS */ PCR.PER_CM_TRGR_ID
, PCR.CM_TRGR_ID
, PCR.BUSINESS_GROUP_ID
, PCR.PER_CM_ID
, PCR.REQUEST_ID
, PCR.PROGRAM_APPLICATION_ID
, PCR.PROGRAM_ID
, /* WHO COLUMNS */ PCR.LAST_UPDATE_DATE
, PCR.LAST_UPDATED_BY
, PCR.CREATED_BY
, PCR.CREATION_DATE
FROM BEN_PER_CM_TRGR_F PCR
WHERE PCR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCR.BUSINESS_GROUP_ID) WITH READ ONLY