DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_QUALIFICATIONS

Line 2158: from per_qualifications

2154: -- but not a person_id.
2155: --
2156: cursor csr_qua(p_party_id number) is
2157: select qualification_id, object_version_number
2158: from per_qualifications
2159: where party_id=p_party_id
2160: and person_id is null;
2161: --
2162: -- Cursor for the applicant who has establishment attendances which have a

Line 2177: l_qua_ovn per_qualifications.OBJECT_VERSION_NUMBER%type;

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
2181: --