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

Line 2014: l_person_type_id per_person_types.person_type_id%type;

2010: l_application_received_date date;
2011: l_party_last_update_date date;
2012: l_return_status varchar2(10);
2013: l_applicant_number per_all_people_f.applicant_number%type;
2014: l_person_type_id per_person_types.person_type_id%type;
2015: l_current_employee_flag per_all_people_f.current_employee_flag%type;
2016: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
2017: l_current_npw_flag per_all_people_f.current_npw_flag%type;
2018:

Line 2073: l_person_type per_person_types.system_person_type%type;

2069: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
2070: -- those required for hr_applicant_api.create_applicant
2071: l_application_id number;
2072: l_full_name per_all_people_f.full_name%type;
2073: l_person_type per_person_types.system_person_type%type;
2074: l_ptu_person_type_id number;
2075: -- for disabling the descriptive flex field
2076: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
2077: hr_dflex_utility.l_ignore_dfcode_varray();

Line 3366: FROM per_person_types typ

3362: and asg2.supervisor_id=per2.person_id
3363: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date
3364: and per2.last_name=p_manager_last_name))
3365: and exists(SELECT 1
3366: FROM per_person_types typ
3367: ,per_person_type_usages_f ptu
3368: WHERE typ.system_person_type = 'EX_EMP'
3369: AND typ.person_type_id = ptu.person_type_id
3370: AND sysdate BETWEEN ptu.effective_start_date