APPS.XNP_CVU_PKG dependencies on XNP_GEO_AREAS_B

Line 145: FROM xnp_geo_areas_b

141: l_code VARCHAR2(40) := NULL;
142: BEGIN
143: SELECT code
144: INTO l_code
145: FROM xnp_geo_areas_b
146: WHERE geo_area_id = id;
147: RETURN l_code;
148: END;
149:

Line 502: START WITH parent_geo_area_id = (select geo_area_id from xnp_geo_areas_b

498: FROM xnp_geo_hierarchy ghi
499: WHERE ghi.child_geo_area_id = gho.child_geo_area_id
500: AND ghi.parent_geo_area_id = gho.parent_geo_area_id
501: -- START WITH parent_geo_area_id = 0
502: START WITH parent_geo_area_id = (select geo_area_id from xnp_geo_areas_b
503: where geo_area_type_code = 'REGION' and
504: code = 'WORLD')
505: CONNECT BY PRIOR child_geo_area_id = parent_geo_area_id);
506: