APPS.PER_ADD_BUS dependencies on PER_BUSINESS_GROUPS

Line 1676: l_legislation_code per_business_groups.legislation_code%TYPE;

1672: -- p_town_or_city ===> district_code
1673: -- p_address_line1 ===> address_line1
1674: -- p_region_1 ===> address_line1_kana
1675:
1676: l_legislation_code per_business_groups.legislation_code%TYPE;
1677: l_town_or_city per_addresses.town_or_city%type;
1678: l_address_line1 per_addresses.address_line1%type;
1679: l_region_1 per_addresses.region_1%type;
1680: l_sql_cursor integer; -- Dynamic sql cursor

Line 1689: from per_business_groups pbg

1685: l_proc varchar2(72) := g_package||'chk_address1_towncity_comb';
1686:
1687: cursor csr_bg is
1688: select legislation_code
1689: from per_business_groups pbg
1690: where pbg.business_group_id = p_business_group_id;
1691:
1692: begin
1693: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 5276: from per_business_groups pbg

5272: -- Declare cursor
5273: --
5274: cursor csr_leg_code is
5275: select pbg.legislation_code
5276: from per_business_groups pbg
5277: , per_addresses adr
5278: where adr.address_id = p_address_id
5279: and pbg.business_group_id = adr.business_group_id;
5280: