eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ADD_BUS dependencies on PER_BUSINESS_GROUPS

Line 1656: l_legislation_code per_business_groups.legislation_code%TYPE;

1652: -- p_town_or_city ===> district_code
1653: -- p_address_line1 ===> address_line1
1654: -- p_region_1 ===> address_line1_kana
1655:
1656: l_legislation_code per_business_groups.legislation_code%TYPE;
1657: l_town_or_city per_addresses.town_or_city%type;
1658: l_address_line1 per_addresses.address_line1%type;
1659: l_region_1 per_addresses.region_1%type;
1660: l_sql_cursor integer; -- Dynamic sql cursor

Line 1669: from per_business_groups pbg

1665: l_proc varchar2(72) := g_package||'chk_address1_towncity_comb';
1666:
1667: cursor csr_bg is
1668: select legislation_code
1669: from per_business_groups pbg
1670: where pbg.business_group_id = p_business_group_id;
1671:
1672: begin
1673: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 5257: from per_business_groups pbg

5253: -- Declare cursor
5254: --
5255: cursor csr_leg_code is
5256: select pbg.legislation_code
5257: from per_business_groups pbg
5258: , per_addresses adr
5259: where adr.address_id = p_address_id
5260: and pbg.business_group_id = adr.business_group_id;
5261: