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_PAY_BASES

Line 81: ,salary_basis per_pay_bases.name%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
85: ,employment_category_meaning hr_lookups.meaning%type default null

Line 315: from per_pay_bases ppb

311: cursor csr_pay_basis
312: (p_pay_basis number) is
313: select ppb.name
314: , ppb.pay_basis
315: from per_pay_bases ppb
316: where ppb.pay_basis_id=p_pay_basis;
317: --
318: cursor csr_ceiling_step
319: (p_special_ceiling_step_id number

Line 754: ,'per_pay_bases ppb_a','ppb_a.pay_basis_id','ppb_a.name');

750: -- Bug 4060365 Changed the parameter from per.prefix to per.pre_name_adjunct
751: l_a_where_clause:=build_varchar2_where('per.pre_name_adjunct',p_condition,p_value);
752: elsif p_field_name='SALARY_BASIS' then
753: l_a_where_clause:=build_varchar2_where('per_asg.pay_basis_id',p_condition,p_value
754: ,'per_pay_bases ppb_a','ppb_a.pay_basis_id','ppb_a.name');
755: l_asg:=TRUE;
756: elsif p_field_name='BARGAINING_UNIT' then
757: -- Bug 4060365 Changed the parameter from per.barganing_unit_code to per.bargaining_unit_code
758: l_a_where_clause:=build_varchar2_where('per_asg.bargaining_unit_code',p_condition,p_value

Line 1220: l_from_clause:=l_from_clause||',per_pay_bases ppb';

1216: if pay_basis_id is not null then
1217: l_where_clause:=l_where_clause||' and per_asg.pay_basis_id='||pay_basis_id;
1218: l_asg:=TRUE;
1219: elsif salary_basis is not null then
1220: l_from_clause:=l_from_clause||',per_pay_bases ppb';
1221: l_where_clause:=l_where_clause||' and per_asg.pay_basis_id=ppb.pay_basis_id'
1222: ||' and upper(ppb.name) like ('''||upper(replace(salary_basis,g_quote,g_quote||g_quote))||''')'
1223: ||' and ppb.business_group_id = per.business_group_id';
1224: l_asg:=TRUE;

Line 2507: ,salary_basis in per_pay_bases.name%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
2511: ,employment_category_meaning in hr_lookups.meaning%type default null