APPS.PER_PL_ADDRESS dependencies on PER_ADDRESSES

Line 32: FROM per_addresses pp

28: SELECT 'Y'
29: INTO l_status
30: FROM sys.dual
31: WHERE exists(SELECT '1'
32: FROM per_addresses pp
33: WHERE (p_address_id IS NULL
34: OR p_address_id <> pp.address_id)
35: AND p_person_id = pp.person_id
36: AND p_address_type = pp.address_type

Line 147: FROM per_addresses

143: IS
144: --
145: CURSOR get_style(p_address_id number) is
146: SELECT style,person_id
147: FROM per_addresses
148: WHERE address_id=p_address_id;
149: --
150: l_style per_addresses.style%TYPE;
151: l_person_id per_addresses.person_id%TYPE;

Line 150: l_style per_addresses.style%TYPE;

146: SELECT style,person_id
147: FROM per_addresses
148: WHERE address_id=p_address_id;
149: --
150: l_style per_addresses.style%TYPE;
151: l_person_id per_addresses.person_id%TYPE;
152: --
153: BEGIN
154: --

Line 151: l_person_id per_addresses.person_id%TYPE;

147: FROM per_addresses
148: WHERE address_id=p_address_id;
149: --
150: l_style per_addresses.style%TYPE;
151: l_person_id per_addresses.person_id%TYPE;
152: --
153: BEGIN
154: --
155: /* Added for GSI Bug 5472781 */

Line 188: l_person_id per_addresses.person_id%TYPE;

184: p_address_line1 IN VARCHAR2,
185: p_address_line2 IN VARCHAR2)
186: IS
187: --
188: l_person_id per_addresses.person_id%TYPE;
189: --
190: BEGIN
191: --
192: /* Added for GSI Bug 5472781 */