APPS.CN_JOB_TITLE_PVT dependencies on CN_JOB_TITLES

Line 487: (p_job_title_id IN cn_job_titles.job_title_id%type,

483: --
484: -- End of comments
485:
486: PROCEDURE Get_Job_Details
487: (p_job_title_id IN cn_job_titles.job_title_id%type,
488: x_result_tbl OUT NOCOPY job_role_tbl_type) IS
489:
490: l_count NUMBER := 1;
491:

Line 533: l_name cn_job_titles.name%type;

529: x_result_tbl OUT NOCOPY job_title_tbl_type) IS
530:
531: rec job_title_rec_type;
532: l_index NUMBER := 0;
533: l_name cn_job_titles.name%type;
534: l_code cn_job_titles.job_code%type;
535:
536: cursor get_data is
537: select job_title_id, name, job_code,

Line 534: l_code cn_job_titles.job_code%type;

530:
531: rec job_title_rec_type;
532: l_index NUMBER := 0;
533: l_name cn_job_titles.name%type;
534: l_code cn_job_titles.job_code%type;
535:
536: cursor get_data is
537: select job_title_id, name, job_code,
538: null role_id, null role_name

Line 539: from cn_job_titles

535:
536: cursor get_data is
537: select job_title_id, name, job_code,
538: null role_id, null role_name
539: from cn_job_titles
540: where upper(name) like l_name
541: and upper(job_code) like l_code
542: order by name;
543:

Line 609: cn_job_titles j,

605: j.job_code,
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