APPS.PER_RO_ADDRESS dependencies on PER_ADDRESSES

Line 8: FROM per_addresses

4: g_package VARCHAR2(33) := 'per_ro_address.';
5:
6: CURSOR c_get_style(p_address_id number) is
7: SELECT style,person_id
8: FROM per_addresses
9: WHERE address_id=p_address_id;
10: --
11: PROCEDURE check_address_unique(
12: p_address_ID IN NUMBER , p_address_type IN VARCHAR2,

Line 25: FROM per_addresses pa

21: l_duplicate_flag boolean default FALSE;
22:
23: cursor c_duplicate_address(p_person_id NUMBER, p_address_type VARCHAR2, p_address_id NUMBER, p_date_from DATE, p_date_to DATE) is
24: SELECT address_id
25: FROM per_addresses pa
26: WHERE pa.person_id = p_person_id
27: AND pa.address_type = p_address_type
28: AND (
29: pa.address_id <> p_address_id

Line 188: l_style per_addresses.style%TYPE;

184: p_address_line3 IN VARCHAR2
185: )
186: IS
187: --
188: l_style per_addresses.style%TYPE;
189: l_person_id per_addresses.person_id%TYPE;
190: --
191: BEGIN
192: --

Line 189: l_person_id per_addresses.person_id%TYPE;

185: )
186: IS
187: --
188: l_style per_addresses.style%TYPE;
189: l_person_id per_addresses.person_id%TYPE;
190: --
191: BEGIN
192: --
193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

Line 230: l_style per_addresses.style%TYPE;

226: p_address_line3 IN VARCHAR2
227: )
228: IS
229: --
230: l_style per_addresses.style%TYPE;
231: l_person_id per_addresses.person_id%TYPE;
232: --
233: BEGIN
234: --

Line 231: l_person_id per_addresses.person_id%TYPE;

227: )
228: IS
229: --
230: l_style per_addresses.style%TYPE;
231: l_person_id per_addresses.person_id%TYPE;
232: --
233: BEGIN
234: --
235: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN