View: PA_JOB_GROUPS_VIEW

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_JOB_GROUPS_VIEW

View Text

SELECT DISTINCT PJG.DISPLAYED_NAME
, PJG.JOB_GROUP_ID
, PJG.MASTER_FLAG
FROM PER_JOB_GROUPS PJG
WHERE ((PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = PJG.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y')

Columns