APPS.CN_JOB_TITLE_PVT dependencies on CN_SRP_ROLES

Line 49: cn_srp_roles sr

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
53: and sj.srp_id = sr.salesrep_id