1. Tables and Views
  2. PSC_COM_JOBFUNC_PROF_GRP_V

PSC_COM_JOBFUNC_PROF_GRP_V

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: VIEW

Columns

Name

PERSON_ID

AGENCY_ID

JOB_FUNC_ID

Query

SQL_Statement

select PERSON_ID,agency_id,JOB_FUNC_ID

FROM psc_com_pers_job_func

WHERE enabled_flag='Y'

union

select prof.PERSON_ID,prof.agency_id,grp.job_func_id

from PSC_COM_PERSON_PROF prof,psc_com_job_grp_func grp

where prof.JOB_FUNC_GRP_ID=grp.JOB_FUNC_GRP_ID

and grp.enabled_flag='Y'