APPS.HR_APPLICANT_API dependencies on PER_PHONES

Line 264: l_phn_object_version_number per_phones.object_version_number%TYPE;

260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;
264: l_phn_object_version_number per_phones.object_version_number%TYPE;
265: l_phone_id per_phones.phone_id%TYPE;
266: --
267: --
268: lv_applicant_number varchar2(2000) := p_applicant_number ;

Line 265: l_phone_id per_phones.phone_id%TYPE;

261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;
264: l_phn_object_version_number per_phones.object_version_number%TYPE;
265: l_phone_id per_phones.phone_id%TYPE;
266: --
267: --
268: lv_applicant_number varchar2(2000) := p_applicant_number ;
269: --

Line 1734: from per_phones

1730: -- but not a person_id.
1731: --
1732: cursor csr_phn(p_party_id number) is
1733: select phone_id, object_version_number
1734: from per_phones
1735: where party_id=p_party_id
1736: and parent_id is null;
1737: --
1738: -- Cursor for the applicant who has previous employers which have a party_id on it,

Line 1768: l_phn_ovn per_phones.OBJECT_VERSION_NUMBER%type;

1764: --
1765: --
1766:
1767: l_add_ovn per_addresses.OBJECT_VERSION_NUMBER%type;
1768: l_phn_ovn per_phones.OBJECT_VERSION_NUMBER%type;
1769: l_parent_table per_phones.PARENT_TABLE%type;
1770: l_pem_ovn per_previous_employers.OBJECT_VERSION_NUMBER%type;
1771: l_qua_ovn per_qualifications.OBJECT_VERSION_NUMBER%type;
1772: l_esa_ovn per_establishment_attendances.OBJECT_VERSION_NUMBER%type;

Line 1769: l_parent_table per_phones.PARENT_TABLE%type;

1765: --
1766:
1767: l_add_ovn per_addresses.OBJECT_VERSION_NUMBER%type;
1768: l_phn_ovn per_phones.OBJECT_VERSION_NUMBER%type;
1769: l_parent_table per_phones.PARENT_TABLE%type;
1770: l_pem_ovn per_previous_employers.OBJECT_VERSION_NUMBER%type;
1771: l_qua_ovn per_qualifications.OBJECT_VERSION_NUMBER%type;
1772: l_esa_ovn per_establishment_attendances.OBJECT_VERSION_NUMBER%type;
1773: --