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 417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%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
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 446: l_supervisor per_all_people_f.full_name%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: --
450: cursor get_pos_defs is

Line 659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%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
662: --
663: l_proc varchar2(72) :=g_package||'get_org_defaults';

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

829: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
830: ,p_defaulting IN varchar2
831: ,p_effective_date IN date
832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type

Line 859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%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
862: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
863: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type