DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_ADDRESSES

Line 1725: from per_addresses

1721: -- but not a person_id.
1722: --
1723: cursor csr_add(p_party_id number) is
1724: select address_id, object_version_number
1725: from per_addresses
1726: where party_id=p_party_id
1727: and person_id is null;
1728: --
1729: -- Cursor for the applicant who has phone numbers which have a party_id on it,

Line 1767: l_add_ovn per_addresses.OBJECT_VERSION_NUMBER%type;

1763: and person_id is null;
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;