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_FUNDS_PUB dependencies on OZF_THRESHOLDS_VL

Line 109: FROM ozf_thresholds_vl

105: AND category_name = p_category_name;
106:
107: CURSOR c_thrh_exists (p_threshold_id IN NUMBER, p_threshold_name IN VARCHAR2) IS
108: SELECT 1
109: FROM ozf_thresholds_vl
110: WHERE threshold_type = 'BUDGET'
111: AND end_date_active > sysdate
112: AND name = p_threshold_name
113: AND threshold_id = p_threshold_id;

Line 117: FROM ozf_thresholds_vl

113: AND threshold_id = p_threshold_id;
114:
115: CURSOR c_thrh_id_exists (p_threshold_id IN NUMBER) IS
116: SELECT 1
117: FROM ozf_thresholds_vl
118: WHERE threshold_type = 'BUDGET'
119: AND end_date_active > sysdate
120: AND threshold_id = p_threshold_id;
121:

Line 124: FROM ozf_thresholds_vl

120: AND threshold_id = p_threshold_id;
121:
122: CURSOR c_thrh_name_exists (p_threshold_name IN VARCHAR2) IS
123: SELECT threshold_id
124: FROM ozf_thresholds_vl
125: WHERE threshold_type = 'BUDGET'
126: AND end_date_active > sysdate
127: AND name = p_threshold_name;
128:

Line 2871: FROM ozf_thresholds_vl

2867: WHERE fund_number = cv_fund_number;
2868:
2869: CURSOR c_threshold_id (cv_threshold_id IN NUMBER) IS
2870: SELECT threshold_id
2871: FROM ozf_thresholds_vl
2872: WHERE threshold_type = 'BUDGET'
2873: AND end_date_active > SYSDATE
2874: AND threshold_id = cv_threshold_id;
2875: