DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT dependencies on CN_SRP_ROLE_DTLS_V

Line 18: FROM cn_srp_role_dtls_v sr

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');