[Home] [Help]
View: PA_JOBS_V
Product: | PA - Projects |
Description: | 10SC Only |
Implementation/DBA Data: |
APPS.PA_JOBS_V
|
View Text
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')
Columns
Name |
JOB_ID |
NAME |
DATE_FROM |
DATE_TO |
JOB_GROUP_ID |