DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 1743: from per_previous_employers

1739: -- but not a person_id.
1740: --
1741: cursor csr_pem(p_party_id number) is
1742: select previous_employer_id, object_version_number
1743: from per_previous_employers
1744: where party_id=p_party_id
1745: and person_id is null;
1746: --
1747: -- Cursor for the applicant who has qualifications which have a party_id on it,

Line 1770: l_pem_ovn per_previous_employers.OBJECT_VERSION_NUMBER%type;

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: --
1774: --end for i-rec enhancement ww bug # 2675202