VIEW: APPS.PA_JOBS_V

Source

View Text - Preformatted

SELECT J.JOB_ID , J.NAME , J.DATE_FROM , J.DATE_TO , J.JOB_GROUP_ID FROM PER_JOBS J WHERE ((J.business_group_id = pa_utils.business_group_id and pa_cross_business_grp.IsCrossBGProfile='N') OR pa_cross_business_grp.IsCrossBGProfile ='Y')

View Text - HTML Formatted

SELECT J.JOB_ID
, J.NAME
, J.DATE_FROM
, J.DATE_TO
, J.JOB_GROUP_ID
FROM PER_JOBS J
WHERE ((J.BUSINESS_GROUP_ID = PA_UTILS.BUSINESS_GROUP_ID
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')