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 PER_ALL_PEOPLE_F

Line 197: l_full_name per_all_people_f.full_name%type;

193: (p_person_id number
194: ,p_effective_date date) return varchar2 is
195: --
196: l_proc varchar2(72) :=g_package||'get_full_name';
197: l_full_name per_all_people_f.full_name%type;
198: --
199: cursor csr_full_name is
200: select full_name
201: from per_all_people_f

Line 201: from per_all_people_f

197: l_full_name per_all_people_f.full_name%type;
198: --
199: cursor csr_full_name is
200: select full_name
201: from per_all_people_f
202: where person_id=p_person_id
203: and p_effective_date between effective_start_date and effective_end_date;
204: begin
205: --

Line 410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
412: ,p_grade OUT NOCOPY per_grades.name%type
413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
414: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 439: l_supervisor per_all_people_f.full_name%type;

435: l_probation_unit_meaning hr_lookups.meaning%type;
436: l_salary_basis per_pay_bases.name%type;
437: l_pay_basis per_pay_bases.pay_basis%type;
438: l_payroll pay_all_payrolls_f.payroll_name%type;
439: l_supervisor per_all_people_f.full_name%type;
440: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
441: l_dummy number;
442: --
443: cursor get_pos_defs is

Line 652: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
652: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
653: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
654: ) is
655: --
656: l_proc varchar2(72) :=g_package||'get_org_defaults';

Line 826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type

822: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
823: ,p_defaulting IN varchar2
824: ,p_effective_date IN date
825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type

Line 852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type

848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
854: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
855: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
856: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type