APPS.HR_HK_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 20: ,p_comments IN per_addresses.comments%TYPE DEFAULT NULL

16: ,p_primary_flag IN VARCHAR2
17: ,p_date_from IN DATE
18: ,p_date_to IN DATE DEFAULT NULL
19: ,p_address_type IN VARCHAR2 DEFAULT NULL
20: ,p_comments IN per_addresses.comments%TYPE DEFAULT NULL
21: ,p_address_line1 IN VARCHAR2
22: ,p_address_line2 IN VARCHAR2 DEFAULT NULL
23: ,p_address_line3 IN VARCHAR2 DEFAULT NULL
24: ,p_district IN VARCHAR2 DEFAULT NULL

Line 125: ,p_comments IN per_addresses.comments%TYPE DEFAULT hr_api.g_varchar2

121: ,p_object_version_number IN OUT NOCOPY NUMBER
122: ,p_date_from IN DATE DEFAULT hr_api.g_date
123: ,p_date_to IN DATE DEFAULT hr_api.g_date
124: ,p_address_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
125: ,p_comments IN per_addresses.comments%TYPE DEFAULT hr_api.g_varchar2
126: ,p_address_line1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
127: ,p_address_line2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
128: ,p_address_line3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
129: ,p_district IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 161: l_style per_addresses.style%TYPE;

157: --
158: -- Declare cursors and local variables
159: --
160: l_proc VARCHAR2(72) := g_package||'update_hk_person_address';
161: l_style per_addresses.style%TYPE;
162: --
163: CURSOR csr_add_style IS
164: SELECT style
165: FROM per_addresses

Line 165: FROM per_addresses

161: l_style per_addresses.style%TYPE;
162: --
163: CURSOR csr_add_style IS
164: SELECT style
165: FROM per_addresses
166: WHERE address_id = p_address_id;
167: --
168: BEGIN
169: hr_utility.set_location('Entering:'|| l_proc, 5);