DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ADDRESSES

Line 2131: from per_addresses

2127: -- but not a person_id.
2128: --
2129: cursor csr_add(p_party_id number) is
2130: select address_id, object_version_number
2131: from per_addresses
2132: where party_id=p_party_id
2133: and person_id is null;
2134: --
2135: -- Cursor for the applicant who has phone numbers which have a party_id on it,

Line 2173: l_add_ovn per_addresses.OBJECT_VERSION_NUMBER%type;

2169: and person_id is null;
2170: --
2171: --
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;