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.XNP_UTILS dependencies on XNP_GEO_AREAS_B

Line 119: l_geo_area_name XNP_GEO_AREAS_B.CODE%TYPE ;

115: FUNCTION GET_GEO_INFO ( P_PORTING_ID IN VARCHAR2 )
116: RETURN VARCHAR2
117: IS
118: l_subscription_tn VARCHAR2(10) ;
119: l_geo_area_name XNP_GEO_AREAS_B.CODE%TYPE ;
120:
121: CURSOR get_geo_area (subscription_tn IN VARCHAR2) IS
122: SELECT geo.code FROM xnp_geo_areas_b geo
123: WHERE geo.geo_area_id IN (SELECT nre.geo_area_id

Line 122: SELECT geo.code FROM xnp_geo_areas_b geo

118: l_subscription_tn VARCHAR2(10) ;
119: l_geo_area_name XNP_GEO_AREAS_B.CODE%TYPE ;
120:
121: CURSOR get_geo_area (subscription_tn IN VARCHAR2) IS
122: SELECT geo.code FROM xnp_geo_areas_b geo
123: WHERE geo.geo_area_id IN (SELECT nre.geo_area_id
124: FROM xnp_number_ranges nre
125: WHERE subscription_tn BETWEEN
126: starting_number AND ending_number );