APPS.BIS_PAGE_PUB dependencies on AK_REGIONS

Line 74: from ak_regions

70: where function_name = p_internal_name;
71:
72: if (l_count = 0) then
73: select count(1) into l_count
74: from ak_regions
75: where region_code = p_internal_name
76: and region_application_id = p_application_id;
77: end if;
78:

Line 207: from ak_regions

203: where function_name = l_new_internal_name;
204:
205: if (l_count = 0) then
206: select count(1) into l_count
207: from ak_regions
208: where region_code = l_new_internal_name
209: and region_application_id = l_new_application_id;
210: end if;
211:

Line 783: from ak_regions

779: l_index NUMBER := 0;
780: l_ascii NUMBER;
781: cursor regions_cursor(p_region_code varchar2) IS
782: select region_code
783: from ak_regions
784: where region_code like p_region_code || '%'
785: and region_application_id = p_application_id;
786:
787: BEGIN

Line 861: from ak_regions

857:
858: -- Check if Region code exists.
859: begin
860: select 1, attribute_category into l_count, l_attr_category
861: from ak_regions
862: where region_code = p_internal_name
863: and region_application_id = p_application_id;
864: exception
865: when no_data_found then l_count := 0;