SELECT distinct job_id, name, date_from, date_to from per_jobs_v V WHERE ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y')
SELECT DISTINCT JOB_ID
, NAME
, DATE_FROM
, DATE_TO
FROM PER_JOBS_V V
WHERE ((PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y')
|
|
|