VIEW: APPS.BENBV_DSGN_RQMT_RLSHP_TYP_V

Source

View Text - Preformatted

SELECT /* descriptive flexfield */ '_DF:BEN:BEN_DSGN_RQMT_RLSHP_TYP_F:DRR', /* codes */ DRR.RLSHP_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('CONTACT',DRR.RLSHP_TYP_CD), /* id columns */ DRR.DSGN_RQMT_RLSHP_TYP_ID, DRR.BUSINESS_GROUP_ID, DRR.DSGN_RQMT_ID, /* who columns */ DRR.LAST_UPDATE_DATE, DRR.LAST_UPDATED_BY, DRR.CREATED_BY, DRR.CREATION_DATE FROM BEN_DSGN_RQMT_RLSHP_TYP DRR WHERE DRR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, DRR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_DSGN_RQMT_RLSHP_TYP_F:DRR'
, /* CODES */ DRR.RLSHP_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('CONTACT'
, DRR.RLSHP_TYP_CD)
, /* ID COLUMNS */ DRR.DSGN_RQMT_RLSHP_TYP_ID
, DRR.BUSINESS_GROUP_ID
, DRR.DSGN_RQMT_ID
, /* WHO COLUMNS */ DRR.LAST_UPDATE_DATE
, DRR.LAST_UPDATED_BY
, DRR.CREATED_BY
, DRR.CREATION_DATE
FROM BEN_DSGN_RQMT_RLSHP_TYP DRR
WHERE DRR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, DRR.BUSINESS_GROUP_ID) WITH READ ONLY