View: BENBV_PRTT_CLM_GD_OR_SVC_TYP_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the provided goods and/or services for which a participant is seeking reimbursement.
Implementation/DBA Data:	APPS.BENBV_PRTT_CLM_GD_OR_SVC_TYP_V

View Text

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

Columns