DBA Data[Home] [Help]

APPS.HR_RO_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 175: l_style per_addresses.style%TYPE;

171: ,p_party_id in number default null
172: ) AS
173:
174: l_proc varchar2(72) ;
175: l_style per_addresses.style%TYPE;
176: l_address_exists boolean := true;
177: --
178: cursor csr_add_style is
179: select style

Line 180: from per_addresses

176: l_address_exists boolean := true;
177: --
178: cursor csr_add_style is
179: select style
180: from per_addresses
181: where address_id = p_address_id;
182: --
183: BEGIN
184:

Line 318: l_style per_addresses.style%TYPE;

314: --
315: -- Declare cursors and local variables
316: --
317: l_proc varchar2(72) ;
318: l_style per_addresses.style%TYPE;
319: l_address_exists boolean := true;
320: --
321: cursor csr_add_style is
322: select style

Line 323: from per_addresses

319: l_address_exists boolean := true;
320: --
321: cursor csr_add_style is
322: select style
323: from per_addresses
324: where address_id = p_address_id;
325: --
326: BEGIN
327: