APPS.GHR_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 372: l_object_version_number per_addresses.object_version_number%type;

368: --
369: -- Declare cursors and local variables
370: --
371: l_proc varchar2(72) := g_package||'update_us_person_address';
372: l_object_version_number per_addresses.object_version_number%type;
373: --
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 5);
376: --

Line 520: l_object_version_number per_addresses.object_version_number%type;

516: --
517: -- Declare cursors and local variables
518: --
519: l_proc varchar2(72) := g_package||'update_us_int_person_address';
520: l_object_version_number per_addresses.object_version_number%type;
521: l_style varchar2(80);
522: --
523: cursor csr_add_style is
524: select style

Line 525: from per_addresses

521: l_style varchar2(80);
522: --
523: cursor csr_add_style is
524: select style
525: from per_addresses
526: where address_id = p_address_id;
527: --
528: begin
529: hr_utility.set_location('Entering:'|| l_proc, 5);