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_REQUISITIONS

Line 79: ,requisition per_requisitions.name%type default null

75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null

Line 80: ,requisition_id per_requisitions.requisition_id%type default null

76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null

Line 307: , per_requisitions rec

303: (p_vacancy_id number) is
304: select vac.name
305: , rec.name
306: from per_vacancies vac
307: , per_requisitions rec
308: where vac.vacancy_id=p_vacancy_id
309: and vac.requisition_id=rec.requisition_id;
310: --
311: cursor csr_pay_basis

Line 644: ,'per_all_vacancies vac_a2,per_requisitions rec_a','vac_a2.vacancy_id','rec_a.name'

640: ,'per_all_vacancies vac_a','vac_a.vacancy_id','vac_a.name');
641: l_asg:=TRUE;
642: elsif p_field_name='REQUISITION' then
643: l_a_where_clause:=build_varchar2_where('per_asg.vacancy_id',p_condition,p_value
644: ,'per_all_vacancies vac_a2,per_requisitions rec_a','vac_a2.vacancy_id','rec_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

Line 1203: l_from_clause:=l_from_clause||',per_requisitions rec';

1199: l_from_clause:=l_from_clause||',per_all_vacancies vac';
1200: l_where_clause:=l_where_clause||' and per_asg.vacancy_id=vac.vacancy_id'
1201: ||' and vac.business_group_id = per.business_group_id';
1202: end if;
1203: l_from_clause:=l_from_clause||',per_requisitions rec';
1204: l_where_clause:=l_where_clause||' and vac.requisition_id=rec.requisition_id'
1205: ||' and upper(rec.name) like ('''||upper(replace(requisition,g_quote,g_quote||g_quote))||''')';
1206: else
1207: l_from_clause:=l_from_clause||',per_all_vacancies vac, per_requisitions rec';

Line 1207: l_from_clause:=l_from_clause||',per_all_vacancies vac, per_requisitions rec';

1203: l_from_clause:=l_from_clause||',per_requisitions rec';
1204: l_where_clause:=l_where_clause||' and vac.requisition_id=rec.requisition_id'
1205: ||' and upper(rec.name) like ('''||upper(replace(requisition,g_quote,g_quote||g_quote))||''')';
1206: else
1207: l_from_clause:=l_from_clause||',per_all_vacancies vac, per_requisitions rec';
1208: l_where_clause:=l_where_clause||' and vac.requisition_id,rec.requisition_id'
1209: ||' and vac.requisition_id=rec.requisition_id'
1210: ||' and vac.vacancy_id=per_asg.vacancy_id'
1211: ||' and upper(rec.name) like ('''||upper(replace(requisition,g_quote,g_quote||g_quote))||''')';

Line 2505: ,requisition in per_requisitions.name%type default null

2501: ,people_group in pay_people_groups.group_name%type default null
2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2503: ,vacancy in per_vacancies.name%type default null
2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null

Line 2506: ,requisition_id in per_requisitions.requisition_id%type default null

2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2503: ,vacancy in per_vacancies.name%type default null
2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null