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_CORE dependencies on XNP_NUMBER_RANGES

Line 15: FROM xnp_number_ranges

11: )
12: IS
13: CURSOR c_ASSIGNED_SP_ID IS
14: SELECT assigned_sp_id
15: FROM xnp_number_ranges
16: WHERE starting_number <= p_starting_number
17: AND ending_number >= p_ending_number
18: AND active_flag = 'Y';
19:

Line 274: FROM xnp_number_ranges

270: l_starting_geo_id NUMBER := null;
271:
272: CURSOR c_starting_geo_id IS
273: SELECT geo_area_id
274: FROM xnp_number_ranges
275: WHERE starting_number <= p_starting_number
276: AND ending_number >= p_ending_number
277: AND sysdate >= effective_date;
278:

Line 566: FROM xnp_number_ranges

562: IS
563:
564: CURSOR c_number_range_id IS
565: SELECT number_range_id
566: FROM xnp_number_ranges
567: WHERE starting_number <= p_starting_number
568: AND ending_number >= p_ending_number
569: AND sysdate >= effective_date
570: AND active_flag='Y';

Line 3664: FROM xnp_number_ranges

3660: l_PORTED_INDICATOR VARCHAR2(40) := NULL;
3661:
3662: CURSOR c_PORTED_INDICATOR IS
3663: SELECT ported_indicator
3664: FROM xnp_number_ranges
3665: WHERE starting_number <= p_starting_number
3666: AND ending_number >= p_ending_number;
3667:
3668: BEGIN