APPS.IRC_PARTY_API dependencies on PER_PERSON_TYPES

Line 2040: l_person_type_id per_person_types.person_type_id%type;

2036: l_application_received_date date;
2037: l_party_last_update_date date;
2038: l_return_status varchar2(10);
2039: l_applicant_number per_all_people_f.applicant_number%type;
2040: l_person_type_id per_person_types.person_type_id%type;
2041: l_current_employee_flag per_all_people_f.current_employee_flag%type;
2042: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
2043: l_current_npw_flag per_all_people_f.current_npw_flag%type;
2044:

Line 2099: l_person_type per_person_types.system_person_type%type;

2095: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
2096: -- those required for hr_applicant_api.create_applicant
2097: l_application_id number;
2098: l_full_name per_all_people_f.full_name%type;
2099: l_person_type per_person_types.system_person_type%type;
2100: l_ptu_person_type_id number;
2101: -- for disabling the descriptive flex field
2102: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
2103: hr_dflex_utility.l_ignore_dfcode_varray();

Line 3491: FROM per_person_types typ

3487: and asg2.supervisor_id=per2.person_id
3488: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date
3489: and UPPER(per2.last_name)=UPPER(p_manager_last_name)))
3490: and exists(SELECT 1
3491: FROM per_person_types typ
3492: ,per_person_type_usages_f ptu
3493: WHERE typ.system_person_type = 'EX_EMP'
3494: AND typ.person_type_id = ptu.person_type_id
3495: AND sysdate BETWEEN ptu.effective_start_date

Line 5855: per_person_types pet

5851: --
5852: cursor csr_sys_person_type(c_person_id number) is
5853: select pet.system_person_type
5854: from per_all_people_f per,
5855: per_person_types pet
5856: where per.person_type_id = pet.person_type_id
5857: and per.person_id = c_person_id
5858: and trunc(sysdate) between per.effective_start_date and per.effective_end_date;
5859: --

Line 5868: l_s_person_type per_person_types.system_person_type%type;

5864: and trunc(sysdate) between effective_start_date and effective_end_date;
5865: --
5866: -- Variable declarations
5867: --
5868: l_s_person_type per_person_types.system_person_type%type;
5869: l_ptu_id per_person_type_usages_f.person_type_usage_id%type;
5870: --
5871: --
5872: begin

Line 6175: l_person_type_id per_person_types.person_type_id%type;

6171: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6172: l_application_received_date date;
6173: l_party_last_update_date date;
6174: l_applicant_number per_all_people_f.applicant_number%type;
6175: l_person_type_id per_person_types.person_type_id%type;
6176: l_current_employee_flag per_all_people_f.current_employee_flag%type;
6177: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
6178: l_current_npw_flag per_all_people_f.current_npw_flag%type;
6179: --

Line 6226: l_person_type per_person_types.system_person_type%type;

6222: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
6223: -- those required for hr_applicant_api.create_applicant
6224: l_application_id number;
6225: l_full_name per_all_people_f.full_name%type;
6226: l_person_type per_person_types.system_person_type%type;
6227: l_ptu_person_type_id number;
6228: -- for disabling the descriptive flex field
6229: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
6230: hr_dflex_utility.l_ignore_dfcode_varray();