[Home] [Help]
14: FROM cn_job_roles jr
15: WHERE jr.job_role_id = p_job_role_id
16: AND EXISTS (
17: SELECT 1
18: FROM cn_srp_role_dtls_v sr
19: WHERE sr.job_title_id = jr.job_title_id
20: AND jr.role_id = sr.role_id );
21:
22: FND_MESSAGE.SET_NAME('CN', 'CN_JOB_ROLE_USED');