APPS.HR_CN_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 117: ,p_comments IN per_addresses.comments%TYPE DEFAULT null

113: ,p_primary_flag IN VARCHAR2
114: ,p_date_from IN DATE
115: ,p_date_to IN DATE DEFAULT null
116: ,p_address_type IN VARCHAR2 DEFAULT null
117: ,p_comments IN per_addresses.comments%TYPE DEFAULT null
118: ,p_address_line1 IN VARCHAR2
119: ,p_address_line2 IN VARCHAR2 DEFAULT null
120: ,p_province_city_sar IN VARCHAR2
121: ,p_postal_code IN VARCHAR2 DEFAULT null

Line 342: ,p_comments IN per_addresses.comments%TYPE DEFAULT null

338: ,p_date_from IN DATE DEFAULT hr_api.g_date
339: ,p_date_to IN DATE DEFAULT hr_api.g_date
340: ,p_primary_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_address_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_comments IN per_addresses.comments%TYPE DEFAULT null
343: ,p_address_line1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_address_line2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_province_city_sar IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 386: l_style per_addresses.style%TYPE;

382: --
383: -- Declare cursors and local variables
384: --
385: l_proc VARCHAR2(72) := g_package||'update_cn_person_address';
386: l_style per_addresses.style%TYPE;
387: --
388: CURSOR csr_add_style IS
389: SELECT style
390: FROM per_addresses

Line 390: FROM per_addresses

386: l_style per_addresses.style%TYPE;
387: --
388: CURSOR csr_add_style IS
389: SELECT style
390: FROM per_addresses
391: WHERE address_id = p_address_id;
392: --
393: BEGIN
394: