APPS.HR_APPLICANT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 2149: from per_previous_employers

2145: -- but not a person_id.
2146: --
2147: cursor csr_pem(p_party_id number) is
2148: select previous_employer_id, object_version_number
2149: from per_previous_employers
2150: where party_id=p_party_id
2151: and person_id is null;
2152: --
2153: -- Cursor for the applicant who has qualifications which have a party_id on it,

Line 2176: l_pem_ovn per_previous_employers.OBJECT_VERSION_NUMBER%type;

2172:
2173: l_add_ovn per_addresses.OBJECT_VERSION_NUMBER%type;
2174: l_phn_ovn per_phones.OBJECT_VERSION_NUMBER%type;
2175: l_parent_table per_phones.PARENT_TABLE%type;
2176: l_pem_ovn per_previous_employers.OBJECT_VERSION_NUMBER%type;
2177: l_qua_ovn per_qualifications.OBJECT_VERSION_NUMBER%type;
2178: l_esa_ovn per_establishment_attendances.OBJECT_VERSION_NUMBER%type;
2179: --
2180: --end for i-rec enhancement ww bug # 2675202