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.OZF_QUOTA_PUB dependencies on OZF_TERR_LEVELS_ALL

Line 1020: FROM ozf_terr_levels_all

1016: WHERE fund_id = p_quota_id;
1017:
1018: CURSOR c_hier_id_exists (p_hier_id IN NUMBER) IS
1019: SELECT heirarchy_id
1020: FROM ozf_terr_levels_all
1021: WHERE heirarchy_id = p_hier_id;
1022:
1023: CURSOR c_from_level_exists (p_hier_id IN NUMBER, p_from_level IN NUMBER) IS
1024: SELECT level_depth

Line 1025: FROM ozf_terr_levels_all

1021: WHERE heirarchy_id = p_hier_id;
1022:
1023: CURSOR c_from_level_exists (p_hier_id IN NUMBER, p_from_level IN NUMBER) IS
1024: SELECT level_depth
1025: FROM ozf_terr_levels_all
1026: WHERE heirarchy_id = p_hier_id
1027: AND level_depth = p_from_level;
1028:
1029: CURSOR c_to_level_exists (p_hier_id IN NUMBER, p_from_level IN NUMBER, p_to_level IN NUMBER) IS

Line 1031: FROM ozf_terr_levels_all

1027: AND level_depth = p_from_level;
1028:
1029: CURSOR c_to_level_exists (p_hier_id IN NUMBER, p_from_level IN NUMBER, p_to_level IN NUMBER) IS
1030: SELECT level_depth
1031: FROM ozf_terr_levels_all
1032: WHERE heirarchy_id = p_hier_id
1033: AND level_depth >= p_from_level
1034: AND level_depth = p_to_level;
1035: