APPS.BIS_BIA_DIM_MAP_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

       select
	con.name name
	from BIS_TERRITORY_HIERARCHIES ter,
	bis_countries_v con
	where ter.CHILD_TERRITORY_CODE = con.country_code
	and ter.parent_territory_code = l_AREA_CODE;

Line: 44

INSERT into BIS_TERRITORY_HIERARCHIES (PARENT_TERRITORY_CODE,
					PARENT_TERRITORY_TYPE,
					CHILD_TERRITORY_CODE,
					CHILD_TERRITORY_TYPE,
					START_DATE_ACTIVE,
					END_DATE_ACTIVE,
					CREATED_BY,
					CREATION_DATE,
					LAST_UPDATED_BY,
					LAST_UPDATE_DATE,
					LAST_UPDATE_LOGIN)
				 values(p_area_code,
					'AREA',
					p_country_code,
					'COUNTRY',
					sysdate,
					sysdate,
					g_current_user_id,
					sysdate,
					g_current_user_id,
					sysdate,
					g_current_login_id);

Line: 74

/* This API is been called from UI to delete are_country association.
We need not to do any validation here*/

PROCEDURE DEL_AREA_COUNTRY_ASSO(p_area_code VARCHAR2 )
IS
BEGIN

Delete BIS_TERRITORY_HIERARCHIES where PARENT_TERRITORY_CODE = p_area_code;