DBA Data[Home] [Help]

APPS.CN_JOB_TITLE_PVT dependencies on JTF_RS_ROLES_VL

Line 610: jtf_rs_roles_vl r

606: jr.role_id,
607: r.role_name
608: from cn_job_roles jr,
609: cn_job_titles j,
610: jtf_rs_roles_vl r
611: where jr.job_title_id = j.job_title_id
612: and r.role_type_code= 'SALES_COMP'
613: and (r.member_flag = 'Y' OR r.manager_flag = 'Y') -- added check
614: and jr.role_id = r.role_id