APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_FUNDS_ALL_B

Line 211: FROM ozf_funds_all_b a,

207: c.frequency_period frequency_period,
208: c.repeat_frequency repeat_frequency,
209: c.comparison_type,
210: c.alert_type
211: FROM ozf_funds_all_b a,
212: ozf_thresholds_all_b b,
213: ozf_threshold_rules_all c
214: WHERE a.threshold_id = b.threshold_id
215: AND a.status_code = 'ACTIVE'

Line 225: FROM ozf_funds_all_b a,

221: --This cursor is to get all the resources for the enabled quota thresholds
222: CURSOR c_all_resources
223: IS
224: SELECT DISTINCT a.owner owner
225: FROM ozf_funds_all_b a,
226: ozf_thresholds_all_b b,
227: ozf_threshold_rules_all c
228: WHERE a.threshold_id = b.threshold_id
229: AND a.status_code = 'ACTIVE'

Line 322: FROM ozf_Funds_All_b

318:
319: CURSOR c_owner(p_budget_id NUMBER)
320: IS
321: SELECT owner,parent_fund_id
322: FROM ozf_Funds_All_b
323: WHERE fund_id = p_budget_id;
324:
325: CURSOR c_parent_owner(p_budget_id NUMBER)
326: IS

Line 328: FROM ozf_Funds_All_b

324:
325: CURSOR c_parent_owner(p_budget_id NUMBER)
326: IS
327: SELECT owner
328: FROM ozf_Funds_All_b
329: WHERE fund_id = p_budget_id;
330:
331: CURSOR c_budget_name(p_budget_id NUMBER)
332: IS