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_APPLICANT_API dependencies on PER_PERSON_TYPES

Line 101: ,per_person_types pet

97: ,bus.business_group_id
98: ,bus.legislation_code
99: FROM per_people_f per
100: ,per_business_groups bus
101: ,per_person_types pet
102: WHERE per.person_type_id = pet.person_type_id
103: AND per.business_group_id+0 = bus.business_group_id
104: AND per.person_id = csr_per_details.p_person_id
105: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date

Line 636: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL

632: (p_validate IN BOOLEAN DEFAULT FALSE
633: ,p_hire_date IN DATE
634: ,p_person_id IN per_all_people_f.person_id%TYPE
635: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
636: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
638: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
639: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
640: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 700: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL

696: (p_validate IN BOOLEAN DEFAULT FALSE
697: ,p_hire_date IN DATE
698: ,p_person_id IN per_all_people_f.person_id%TYPE
699: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
700: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
702: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
703: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
704: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL

759: (p_validate IN BOOLEAN DEFAULT FALSE
760: ,p_hire_date IN DATE
761: ,p_person_id IN per_all_people_f.person_id%TYPE
762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE

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

777: l_proc VARCHAR2(72) := g_package||'hire_to_employee_applicant';
778: --
779: l_hire_date DATE;
780: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
781: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
782: l_person_type_id1 per_person_types.person_type_id%TYPE;
783: --
784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
785: l_hire_all_accepted_asgs VARCHAR2(1);

Line 782: l_person_type_id1 per_person_types.person_type_id%TYPE;

778: --
779: l_hire_date DATE;
780: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
781: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
782: l_person_type_id1 per_person_types.person_type_id%TYPE;
783: --
784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
785: l_hire_all_accepted_asgs VARCHAR2(1);
786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 796: l_system_person_type per_person_types.system_person_type%TYPE;

792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
794: l_assign_payroll_warning BOOLEAN;
795: --
796: l_system_person_type per_person_types.system_person_type%TYPE;
797: l_future_asgs_count INTEGER;
798: l_nonaccepted_asgs_count INTEGER;
799: l_accepted_asgs_count INTEGER;
800: l_primary_asgs_count INTEGER;

Line 1190: from per_person_type_usages_f ptuf, per_person_types ppt

1186: -- PTU : Following Code has been added
1187: --
1188: begin
1189: select ptuf.person_type_id into l_person_type_id1
1190: from per_person_type_usages_f ptuf, per_person_types ppt
1191: where ptuf.person_id = p_person_id
1192: and l_hire_date between ptuf.effective_start_date and ptuf.effective_end_date
1193: and ppt.person_type_id = ptuf.person_type_id
1194: and ppt.system_person_type = 'EMP';

Line 1506: l_system_person_type per_person_types.system_person_type%TYPE;

1502: l_unaccepted_asg_del_warning boolean;
1503: --
1504: l_primary_assignment_id number:=p_primary_assignment_id;
1505: --
1506: l_system_person_type per_person_types.system_person_type%TYPE;
1507: l_business_group_id per_all_people_f.business_group_id%TYPE;
1508: l_legislation_code per_business_groups.legislation_code%TYPE;
1509: l_application_id per_applications.application_id%TYPE;
1510: l_apl_object_version_number per_applications.application_id%TYPE;

Line 1587: per_person_types ppt,

1583: pap.application_id,
1584: pap.object_version_number
1585: from per_all_people_f per,
1586: per_business_groups bus,
1587: per_person_types ppt,
1588: per_applications pap
1589: where per.person_type_id = ppt.person_type_id
1590: and per.business_group_id = bus.business_group_id
1591: and per.person_id = pap.person_id