APPS.OZF_THRESHOLD_PVT dependencies on OZF_FUND_DETAILS_V

Line 205: FROM ozf_fund_details_v

201:
202: CURSOR c_committed_amt
203: IS
204: SELECT committed_amt
205: FROM ozf_fund_details_v
206: WHERE fund_id = p_budget_id;
207:
208: CURSOR c_planned_amt
209: IS

Line 211: FROM ozf_fund_details_v

207:
208: CURSOR c_planned_amt
209: IS
210: SELECT planned_amt
211: FROM ozf_fund_details_v
212: WHERE fund_id = p_budget_id;
213:
214:
215: CURSOR c_utilized_amt

Line 218: FROM ozf_fund_details_v

214:
215: CURSOR c_utilized_amt
216: IS
217: SELECT earned_amt
218: FROM ozf_fund_details_v
219: WHERE fund_id = p_budget_id;
220:
221: CURSOR c_earned_amt
222: IS

Line 224: FROM ozf_fund_details_v

220:
221: CURSOR c_earned_amt
222: IS
223: SELECT earned_amt
224: FROM ozf_fund_details_v
225: WHERE fund_id = p_budget_id;
226:
227: CURSOR c_paid_amt
228: IS

Line 230: FROM ozf_fund_details_v

226:
227: CURSOR c_paid_amt
228: IS
229: SELECT paid_amt
230: FROM ozf_fund_details_v
231: WHERE fund_id = p_budget_id;
232:
233: --asylvia 12-May-2006 bug 5199719 - SQL ID 17780673
234: CURSOR c_balance_amt

Line 243: FROM ozf_fund_details_v

239:
240: CURSOR c_re_committed_amt
241: IS
242: SELECT recal_committed
243: FROM ozf_fund_details_v
244: WHERE fund_id = p_budget_id;
245:
246: BEGIN
247: -- Standard call to check for call compatibility.

Line 422: FROM ozf_fund_details_v

418:
419: CURSOR c_committed_amt
420: IS
421: SELECT committed_amt
422: FROM ozf_fund_details_v
423: WHERE fund_id = p_budget_id;
424:
425: CURSOR c_planned_amt
426: IS

Line 428: FROM ozf_fund_details_v

424:
425: CURSOR c_planned_amt
426: IS
427: SELECT planned_amt
428: FROM ozf_fund_details_v
429: WHERE fund_id = p_budget_id;
430:
431:
432: CURSOR c_utilized_amt

Line 435: FROM ozf_fund_details_v

431:
432: CURSOR c_utilized_amt
433: IS
434: SELECT earned_amt
435: FROM ozf_fund_details_v
436: WHERE fund_id = p_budget_id;
437:
438: CURSOR c_earned_amt
439: IS

Line 441: FROM ozf_fund_details_v

437:
438: CURSOR c_earned_amt
439: IS
440: SELECT earned_amt
441: FROM ozf_fund_details_v
442: WHERE fund_id = p_budget_id;
443:
444: CURSOR c_paid_amt
445: IS

Line 447: FROM ozf_fund_details_v

443:
444: CURSOR c_paid_amt
445: IS
446: SELECT paid_amt
447: FROM ozf_fund_details_v
448: WHERE fund_id = p_budget_id;
449:
450: CURSOR c_re_committed_amt
451: IS

Line 453: FROM ozf_fund_details_v

449:
450: CURSOR c_re_committed_amt
451: IS
452: SELECT recal_committed
453: FROM ozf_fund_details_v
454: WHERE fund_id = p_budget_id;
455:
456: BEGIN
457: -- Standard call to check for call compatibility.

Line 993: FROM ozf_fund_details_v

989:
990: CURSOR c_budget_name(p_budget_id NUMBER)
991: IS
992: SELECT short_name
993: FROM ozf_fund_details_v
994: WHERE fund_id = p_budget_id;
995:
996: CURSOR c_valuelimit_name(p_lkup_code VARCHAR2)
997: IS