VIEW: APPS.BENBV_CSS_RLTD_PER_PER_IN_LE_V

Source

View Text - Preformatted

SELECT CSR.EFFECTIVE_START_DATE, CSR.EFFECTIVE_END_DATE, CSR.ORDR_TO_PRCS_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_CSS_RLTD_PER_PER_IN_LER_F:CSR', /* id columns */ CSR.CSS_RLTD_PER_PER_IN_LER_ID, CSR.BUSINESS_GROUP_ID, CSR.LER_ID, CSR.RSLTG_LER_ID, /* who columns */ CSR.LAST_UPDATE_DATE, CSR.LAST_UPDATED_BY, CSR.CREATED_BY, CSR.CREATION_DATE FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR WHERE CSR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CSR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT CSR.EFFECTIVE_START_DATE
, CSR.EFFECTIVE_END_DATE
, CSR.ORDR_TO_PRCS_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CSS_RLTD_PER_PER_IN_LER_F:CSR'
, /* ID COLUMNS */ CSR.CSS_RLTD_PER_PER_IN_LER_ID
, CSR.BUSINESS_GROUP_ID
, CSR.LER_ID
, CSR.RSLTG_LER_ID
, /* WHO COLUMNS */ CSR.LAST_UPDATE_DATE
, CSR.LAST_UPDATED_BY
, CSR.CREATED_BY
, CSR.CREATION_DATE
FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR
WHERE CSR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CSR.BUSINESS_GROUP_ID) WITH READ ONLY