APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on PER_ADDRESSES

Line 10: * from HZ_LOCATIONS / PER_ADDRESSES tables.

6: g_st_party_fname CONSTANT VARCHAR2(30) := 'Dep/Arr Party';
7:
8: /**
9: * Address Record Structure to store the Address Information when retrieved
10: * from HZ_LOCATIONS / PER_ADDRESSES tables.
11: *
12: * *** Filled when address is retrieved from HZ_LOCATIONS Table ***
13: * *** Associated API that fills the records is GET_PARTY_ADDRESSES ***
14: * PARTY_ID Primary Key to HZ_PARTIES Table

Line 19: * *** Filled when address is retrieved from PER_ADDRESSES Table ***

15: * PARTY_SITE_ID Primary Key to HZ_PARTY_SITES Table
16: * LOCATION Primary Key to HZ_LOCATIONS Table
17: * GEOMETRY Spatial Geometry of the Address
18:
19: * *** Filled when address is retrieved from PER_ADDRESSES Table ***
20: * *** Associated API that fills the records is GET_HOME_ADDRESSES ***
21: * ADDRESS_ID Primray Key to PER_ADDRESS Table
22: *
23: * *** Common fields between HZ_LOCATIONS and PER_ADDRESSES Tables ***

Line 23: * *** Common fields between HZ_LOCATIONS and PER_ADDRESSES Tables ***

19: * *** Filled when address is retrieved from PER_ADDRESSES Table ***
20: * *** Associated API that fills the records is GET_HOME_ADDRESSES ***
21: * ADDRESS_ID Primray Key to PER_ADDRESS Table
22: *
23: * *** Common fields between HZ_LOCATIONS and PER_ADDRESSES Tables ***
24: * STREET Address Line 1 Information
25: * CITY City Information
26: * STATE State Information
27: * POSTAL_CODE Postal Code Information

Line 37: , address_id per_addresses.address_id%TYPE

33: TYPE address_rec_type IS RECORD(
34: party_id hz_parties.party_id%TYPE
35: , party_site_id hz_party_sites.party_site_id%TYPE
36: , location_id hz_locations.location_id%TYPE
37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE

Line 63: * PER_ADDRESSES. There can be only one Primary Address for a particular

59: * Resource's Home Address
60: * This is applicable only for Employee Resource (RS_EMPLOYEE).
61: * Employee Resource is an employee defined in HRMS with an address.
62: * Resource's Home Address is nothing but the address as defined in HRMS
63: * PER_ADDRESSES. There can be only one Primary Address for a particular
64: * period of time.
65: *
66: * Resource's Party Information
67: * Any Party created by this API will have CREATED_BY_MODULE as CSFDEAR.