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 2572: from per_person_type_usages_f ptu,per_person_types ppt

2568: -- Bug 3611984 starts here
2569: l_ptu_datetrack_mode varchar2(12);
2570: cursor c_ptu_start_date is
2571: select effective_start_date
2572: from per_person_type_usages_f ptu,per_person_types ppt
2573: where ptu.person_type_id = ppt.person_type_id
2574: and ptu.person_id = p_person_id
2575: and p_hire_date between ptu.effective_start_date and ptu.effective_end_date
2576: and ppt.system_person_type='EX_EMP';

Line 2620: from per_person_types pet,

2616: /* select per.business_group_id,
2617: per.employee_number,
2618: per.effective_start_date,
2619: pet.system_person_type
2620: from per_person_types pet,
2621: per_people_f per
2622: where per.person_id = p_person_id
2623: and pet.person_type_id = per.person_type_id
2624: and pet.business_group_id + 0 = per.business_group_id

Line 2632: from per_person_types pet,

2628: select per.business_group_id,
2629: per.employee_number,
2630: per.effective_start_date,
2631: pet.system_person_type
2632: from per_person_types pet,
2633: per_people_f per,
2634: per_person_type_usages_f ptu
2635: where per.person_id = p_person_id
2636: and pet.person_type_id = ptu.person_type_id

Line 2709: l_system_person_type per_person_types.system_person_type%type;

2705: p_business_group_id out nocopy number,
2706: p_employee_number out nocopy varchar2) is
2707: --
2708: l_proc varchar2(72) := g_package||'perform_validation';
2709: l_system_person_type per_person_types.system_person_type%type;
2710: l_final_process_date per_periods_of_service.final_process_date%type;
2711: l_effective_start_date per_people_f.effective_start_date%type;
2712: l_dummy_number number;
2713: l_dummy_emp_number varchar2(30);

Line 3316: l_system_person_type per_person_types.system_person_type%type;

3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;
3316: l_system_person_type per_person_types.system_person_type%type;
3317: l_effective_date date;
3318: l_effective_start_date date;
3319: l_effective_end_date date;
3320: l_default_start_time per_business_groups.default_start_time%type;

Line 3353: from per_person_types ppt

3349: select ppf.business_group_id
3350: ,ppf.employee_number
3351: ,ppf.npw_number
3352: ,ppt.system_person_type
3353: from per_person_types ppt
3354: ,per_people_f ppf
3355: where ppf.person_id = p_person_id
3356: and ppt.person_type_id = ppf.person_type_id
3357: and ppt.business_group_id + 0 = ppf.business_group_id

Line 3366: from per_person_types

3362: -- Get default person type id for a system person type EMP_APL
3363: --
3364: cursor csr_get_person_type_id is
3365: select person_type_id
3366: from per_person_types
3367: where business_group_id = l_business_group_id
3368: and active_flag = 'Y'
3369: and default_flag = 'Y'
3370: and system_person_type = 'EMP_APL';

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

3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3784: l_assign_payroll_warning BOOLEAN;
3785: l_orig_hire_warning BOOLEAN;
3786: --
3787: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
3788: l_person_type_id1 per_person_types.person_type_id%TYPE;
3789: --
3790: l_future_asgs_count INTEGER;
3791: l_system_person_type per_person_types.system_person_type%TYPE;

Line 3788: l_person_type_id1 per_person_types.person_type_id%TYPE;

3784: l_assign_payroll_warning BOOLEAN;
3785: l_orig_hire_warning BOOLEAN;
3786: --
3787: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
3788: l_person_type_id1 per_person_types.person_type_id%TYPE;
3789: --
3790: l_future_asgs_count INTEGER;
3791: l_system_person_type per_person_types.system_person_type%TYPE;
3792: l_effective_start_date DATE;

Line 3791: l_system_person_type per_person_types.system_person_type%TYPE;

3787: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
3788: l_person_type_id1 per_person_types.person_type_id%TYPE;
3789: --
3790: l_future_asgs_count INTEGER;
3791: l_system_person_type per_person_types.system_person_type%TYPE;
3792: l_effective_start_date DATE;
3793: l_effective_end_date DATE;
3794: l_comment_id hr_comments.comment_id%TYPE;
3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

Line 3857: ,per_person_types pet

3853: ,bus.business_group_id
3854: ,bus.legislation_code
3855: FROM per_people_f per
3856: ,per_business_groups bus
3857: ,per_person_types pet
3858: WHERE per.person_type_id = pet.person_type_id
3859: AND per.business_group_id+0 = bus.business_group_id
3860: AND per.person_id = csr_per_details.p_person_id
3861: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date