DBA Data[Home] [Help]

VIEW: APPS.HRI_CS_JOB_JOB_ROLE_V

Source

View Text - Preformatted

SELECT job_id job_id ,hri_bpl_job.get_job_role_code( job_fmly_code, job_fnctn_code) job_role_code ,'Y' primary_role_for_job_flag FROM hri_cs_jobh_ct
View Text - HTML Formatted

SELECT JOB_ID JOB_ID
, HRI_BPL_JOB.GET_JOB_ROLE_CODE( JOB_FMLY_CODE
, JOB_FNCTN_CODE) JOB_ROLE_CODE
, 'Y' PRIMARY_ROLE_FOR_JOB_FLAG
FROM HRI_CS_JOBH_CT