eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_FIND_QUERY dependencies on PER_JOBS

Line 59: ,job per_jobs.name%type default null

55: ,grade_ladder ben_pgm_f.name%type default null
56: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
63: ,payroll pay_all_payrolls_f.payroll_name%type default null

Line 242: from per_jobs_vl

238: --
239: cursor csr_job
240: (p_job_id number) is
241: select name
242: from per_jobs_vl
243: where job_id=p_job_id;
244: --
245: --Modified for PMxbg
246: cursor csr_asg_status

Line 649: ,'per_jobs_v job_a','job_a.job_id','job_a.name');

645: ,' and vac_a2.requisition_id=rec_a.requisition_id');
646: l_asg:=TRUE;
647: elsif p_field_name='JOB' then
648: l_a_where_clause:=build_varchar2_where('per_asg.job_id',p_condition,p_value
649: ,'per_jobs_v job_a','job_a.job_id','job_a.name');
650: l_asg:=TRUE;
651: elsif p_field_name='POSITION' then
652: -- PMFLETCH - Now using VL translation table
653: l_a_where_clause:=build_varchar2_where('per_asg.position_id',p_condition,p_value

Line 1076: l_from_clause:=l_from_clause||',per_jobs_v job';

1072: if job_id is not null then
1073: l_where_clause:=l_where_clause||' and per_asg.job_id='||job_id;
1074: l_asg:=TRUE;
1075: elsif job is not null then
1076: l_from_clause:=l_from_clause||',per_jobs_v job';
1077: l_where_clause:=l_where_clause||' and per_asg.job_id=job.job_id'
1078: ||' and upper(job.name) like ('''||upper(replace(job,g_quote,g_quote||g_quote))||''')'
1079: ||' and job.business_group_id = per.business_group_id';
1080: l_asg:=TRUE;

Line 2501: ,job in per_jobs.name%type default null

2497: ,grade_ladder in ben_pgm_f.name%type default null
2498: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2505: ,payroll in pay_all_payrolls_f.payroll_name%type default null