VIEW: APPS.BENBV_PRTT_CLM_GD_OR_SVC_TYP_V

Source

View Text - Preformatted

SELECT /* descriptive flexfield */ '_DF:BEN:BEN_PRTT_CLM_GD_OR_SVC_TYP:PCG', /* id columns */ PCG.PRTT_CLM_GD_OR_SVC_TYP_ID, PCG.BUSINESS_GROUP_ID, PCG.PRTT_REIMBMT_RQST_ID, PCG.GD_OR_SVC_TYP_ID, PCG.PL_GD_OR_SVC_ID, /* who columns */ PCG.LAST_UPDATE_DATE, PCG.LAST_UPDATED_BY, PCG.CREATED_BY, PCG.CREATION_DATE FROM BEN_PRTT_CLM_GD_OR_SVC_TYP PCG WHERE PCG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCG.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTT_CLM_GD_OR_SVC_TYP:PCG'
, /* ID COLUMNS */ PCG.PRTT_CLM_GD_OR_SVC_TYP_ID
, PCG.BUSINESS_GROUP_ID
, PCG.PRTT_REIMBMT_RQST_ID
, PCG.GD_OR_SVC_TYP_ID
, PCG.PL_GD_OR_SVC_ID
, /* WHO COLUMNS */ PCG.LAST_UPDATE_DATE
, PCG.LAST_UPDATED_BY
, PCG.CREATED_BY
, PCG.CREATION_DATE
FROM BEN_PRTT_CLM_GD_OR_SVC_TYP PCG
WHERE PCG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCG.BUSINESS_GROUP_ID) WITH READ ONLY