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.HR_EMPLOYEE_API dependencies on PER_PERSON_TYPES

Line 302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;

298: --
299: -- Declare cursors and local variables
300: --
301: l_proc varchar2(72);
302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;

Line 303: l_person_type_id1 per_person_types.person_type_id%type;

299: -- Declare cursors and local variables
300: --
301: l_proc varchar2(72);
302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;

Line 2883: from per_person_type_usages_f ptu,per_person_types ppt

2879: -- Bug 3611984 starts here
2880: l_ptu_datetrack_mode varchar2(12);
2881: cursor c_ptu_start_date is
2882: select effective_start_date
2883: from per_person_type_usages_f ptu,per_person_types ppt
2884: where ptu.person_type_id = ppt.person_type_id
2885: and ptu.person_id = p_person_id
2886: and p_hire_date between ptu.effective_start_date and ptu.effective_end_date
2887: and ppt.system_person_type='EX_EMP';

Line 2931: from per_person_types pet,

2927: /* select per.business_group_id,
2928: per.employee_number,
2929: per.effective_start_date,
2930: pet.system_person_type
2931: from per_person_types pet,
2932: per_people_f per
2933: where per.person_id = p_person_id
2934: and pet.person_type_id = per.person_type_id
2935: and pet.business_group_id + 0 = per.business_group_id

Line 2943: from per_person_types pet,

2939: select per.business_group_id,
2940: per.employee_number,
2941: per.effective_start_date,
2942: pet.system_person_type
2943: from per_person_types pet,
2944: per_people_f per,
2945: per_person_type_usages_f ptu
2946: where per.person_id = p_person_id
2947: and pet.person_type_id = ptu.person_type_id

Line 3020: l_system_person_type per_person_types.system_person_type%type;

3016: p_business_group_id out nocopy number,
3017: p_employee_number out nocopy varchar2) is
3018: --
3019: l_proc varchar2(72) := g_package||'perform_validation';
3020: l_system_person_type per_person_types.system_person_type%type;
3021: l_final_process_date per_periods_of_service.final_process_date%type;
3022: l_effective_start_date per_people_f.effective_start_date%type;
3023: l_dummy_number number;
3024: l_dummy_emp_number varchar2(30);

Line 3628: l_system_person_type per_person_types.system_person_type%type;

3624: l_applicant_number per_people_f.applicant_number%TYPE;
3625: l_npw_number per_people_f.npw_number%TYPE;
3626: l_per_object_version_number per_people_f.object_version_number%TYPE;
3627: l_full_name per_people_f.full_name%type;
3628: l_system_person_type per_person_types.system_person_type%type;
3629: l_effective_date date;
3630: l_effective_start_date date;
3631: l_effective_end_date date;
3632: l_default_start_time per_business_groups.default_start_time%type;

Line 3665: from per_person_types ppt

3661: select ppf.business_group_id
3662: ,ppf.employee_number
3663: ,ppf.npw_number
3664: ,ppt.system_person_type
3665: from per_person_types ppt
3666: ,per_people_f ppf
3667: where ppf.person_id = p_person_id
3668: and ppt.person_type_id = ppf.person_type_id
3669: and ppt.business_group_id + 0 = ppf.business_group_id

Line 3678: from per_person_types

3674: -- Get default person type id for a system person type EMP_APL
3675: --
3676: cursor csr_get_person_type_id is
3677: select person_type_id
3678: from per_person_types
3679: where business_group_id = l_business_group_id
3680: and active_flag = 'Y'
3681: and default_flag = 'Y'
3682: and system_person_type = 'EMP_APL';

Line 4099: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;

4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4096: l_assign_payroll_warning BOOLEAN;
4097: l_orig_hire_warning BOOLEAN;
4098: --
4099: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4100: l_person_type_id1 per_person_types.person_type_id%TYPE;
4101: --
4102: l_future_asgs_count INTEGER;
4103: l_system_person_type per_person_types.system_person_type%TYPE;

Line 4100: l_person_type_id1 per_person_types.person_type_id%TYPE;

4096: l_assign_payroll_warning BOOLEAN;
4097: l_orig_hire_warning BOOLEAN;
4098: --
4099: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4100: l_person_type_id1 per_person_types.person_type_id%TYPE;
4101: --
4102: l_future_asgs_count INTEGER;
4103: l_system_person_type per_person_types.system_person_type%TYPE;
4104: l_effective_start_date DATE;

Line 4103: l_system_person_type per_person_types.system_person_type%TYPE;

4099: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4100: l_person_type_id1 per_person_types.person_type_id%TYPE;
4101: --
4102: l_future_asgs_count INTEGER;
4103: l_system_person_type per_person_types.system_person_type%TYPE;
4104: l_effective_start_date DATE;
4105: l_effective_end_date DATE;
4106: l_comment_id hr_comments.comment_id%TYPE;
4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

Line 4169: ,per_person_types pet

4165: ,bus.business_group_id
4166: ,bus.legislation_code
4167: FROM per_people_f per
4168: ,per_business_groups bus
4169: ,per_person_types pet
4170: WHERE per.person_type_id = pet.person_type_id
4171: AND per.business_group_id+0 = bus.business_group_id
4172: AND per.person_id = csr_per_details.p_person_id
4173: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date