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 PAY_ALL_PAYROLLS_F

Line 63: ,payroll pay_all_payrolls_f.payroll_name%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
64: ,payroll_id per_all_assignments_f.payroll_id%type default null
65: ,location hr_locations.location_code%type default null
66: ,location_id per_all_assignments_f.location_id%type default null
67: ,supervisor per_all_people_f.full_name%type default null

Line 270: from pay_all_payrolls_f

266: cursor csr_payroll
267: (p_payroll_id number
268: ,p_effective_date date) is
269: select payroll_name
270: from pay_all_payrolls_f
271: where payroll_id=p_payroll_id
272: and p_effective_date between effective_start_date and effective_end_date;
273: --
274: cursor csr_location

Line 1108: l_from_clause:=l_from_clause||',pay_all_payrolls_f pay';

1104: if payroll_id is not null then
1105: l_where_clause:=l_where_clause||' and per_asg.payroll_id='||payroll_id;
1106: l_asg:=TRUE;
1107: elsif payroll is not null then
1108: l_from_clause:=l_from_clause||',pay_all_payrolls_f pay';
1109: l_where_clause:=l_where_clause||' and per_asg.payroll_id=pay.payroll_id'
1110: ||' and upper(pay.payroll_name) like ('''||upper(replace(payroll,g_quote,g_quote||g_quote))||''')'
1111: ||' and pay.business_group_id = per.business_group_id'
1112: ||' and '||l_effective_date||' between pay.effective_start_date'

Line 2505: ,payroll in pay_all_payrolls_f.payroll_name%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
2506: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2507: ,location in hr_locations.location_code%type default null
2508: ,location_id in per_all_assignments_f.location_id%type default null
2509: ,supervisor in per_all_people_f.full_name%type default null