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_POPULATE dependencies on PAY_ALL_PAYROLLS_F

Line 171: l_payroll_name pay_all_payrolls_f.payroll_name%type;

167: (p_payroll_id number
168: ,p_effective_date date) return varchar2 is
169: --
170: l_proc varchar2(72) :=g_package||'get_payroll';
171: l_payroll_name pay_all_payrolls_f.payroll_name%type;
172: --
173: cursor csr_payroll is
174: select payroll_name
175: from pay_all_payrolls_f

Line 175: from pay_all_payrolls_f

171: l_payroll_name pay_all_payrolls_f.payroll_name%type;
172: --
173: cursor csr_payroll is
174: select payroll_name
175: from pay_all_payrolls_f
176: where payroll_id=p_payroll_id
177: and p_effective_date between effective_start_date and effective_end_date;
178: begin
179: --

Line 415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type

Line 445: l_payroll pay_all_payrolls_f.payroll_name%type;

441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;
443: l_salary_basis per_pay_bases.name%type;
444: l_pay_basis per_pay_bases.pay_basis%type;
445: l_payroll pay_all_payrolls_f.payroll_name%type;
446: l_supervisor per_all_people_f.full_name%type;
447: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
448: l_dummy number;
449: --

Line 657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
658: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
660: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
661: ) is

Line 857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type

853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type