APPS.AK_REGION2_PVT dependencies on AK_REGIONS

Line 1787: from ak_regions ar, ak_regions_tl art

1783: -- do not update customized data
1784: select ar.last_updated_by, art.last_updated_by,
1785: ar.last_update_date, art.last_update_date
1786: into l_user_id1, l_user_id2, l_update1, l_update2
1787: from ak_regions ar, ak_regions_tl art
1788: where ar.region_code = l_region_tbl(l_index).region_code
1789: and ar.region_application_id = l_region_tbl(l_index).region_application_id
1790: and ar.region_code = art.region_code
1791: and ar.region_application_id = art.region_application_id

Line 4299: from AK_REGIONS

4295: p_pass IN NUMBER := 2
4296: ) return boolean is
4297: cursor l_check_region_csr (param_region_code in varchar2, param_region_appl_id in number) is
4298: select 1
4299: from AK_REGIONS
4300: where region_application_id = param_region_appl_id
4301: and region_code = param_region_code;
4302:
4303: cursor l_check_region_item_csr (param_region_code in varchar2, param_region_appl_id in number,