APPS.CN_JOB_TITLE_PVT dependencies on CN_SRP_JOB_TITLES

Line 48: cn_srp_job_titles sj,

44: SELECT COUNT(sj.srp_id), min(sj.start_date),
45: MAX(sj.end_date)
46: into l_count,l_min_start_date , l_max_end_date
47: from cn_job_roles jr,
48: cn_srp_job_titles sj,
49: cn_srp_roles sr
50: where jr.job_role_id = p_rec.job_role_id
51: and jr.job_title_id = sj.job_title_id
52: and jr.role_id = sr.role_id