APPS.HR_KIOSK_ADDRESS_API dependencies on PER_ADDRESSES

Line 61: l_business_group_id per_addresses.business_group_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_business_group_id per_addresses.business_group_id%TYPE;
62: l_date_from per_addresses.date_from%TYPE;
63: l_proc varchar2(72) := g_package||'create_person_address';
64: --
65: cursor csr_bus_grp is

Line 62: l_date_from per_addresses.date_from%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_business_group_id per_addresses.business_group_id%TYPE;
62: l_date_from per_addresses.date_from%TYPE;
63: l_proc varchar2(72) := g_package||'create_person_address';
64: --
65: cursor csr_bus_grp is
66: select per.business_group_id

Line 445: l_object_version_number per_addresses.object_version_number%TYPE;

441: ) is
442: --
443: -- Declare cursors and local variables
444: --
445: l_object_version_number per_addresses.object_version_number%TYPE;
446: l_proc varchar2(72) := g_package||'update_person_address';
447: --
448: begin
449: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 577: l_style per_addresses.style%TYPE;

573: --
574: -- Declare cursors and local variables
575: --
576: l_proc varchar2(72) := g_package||'update_gb_person_address';
577: l_style per_addresses.style%TYPE;
578: --
579: cursor csr_add_style is
580: select addr.style
581: from per_addresses addr

Line 581: from per_addresses addr

577: l_style per_addresses.style%TYPE;
578: --
579: cursor csr_add_style is
580: select addr.style
581: from per_addresses addr
582: where addr.address_id = p_address_id;
583: --
584: begin
585: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 711: l_style per_addresses.style%TYPE;

707: --
708: -- Declare cursors and local variables
709: --
710: l_proc varchar2(72) := g_package||'update_us_person_address';
711: l_style per_addresses.style%TYPE;
712: --
713: cursor csr_add_style is
714: select style
715: from per_addresses

Line 715: from per_addresses

711: l_style per_addresses.style%TYPE;
712: --
713: cursor csr_add_style is
714: select style
715: from per_addresses
716: where address_id = p_address_id;
717: --
718: begin
719: hr_utility.set_location('Entering:'|| l_proc, 5);