APPS.OZF_THRESHOLD_PVT dependencies on OZF_FUNDS_ALL_B

Line 237: FROM ozf_funds_all_b

233: --asylvia 12-May-2006 bug 5199719 - SQL ID 17780673
234: CURSOR c_balance_amt
235: IS
236: select (NVL(original_budget, 0) + (NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0))) ,committed_amt
237: FROM ozf_funds_all_b
238: WHERE fund_id = p_budget_id;
239:
240: CURSOR c_re_committed_amt
241: IS

Line 415: FROM ozf_funds_all_b

411: --asylvia 12-May-2006 bug 5199719 - SQL ID 17780673
412: CURSOR c_budgeted_amt
413: IS
414: select (NVL(original_budget, 0) + (NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0)))
415: FROM ozf_funds_all_b
416: WHERE fund_id = p_budget_id;
417:
418:
419: CURSOR c_committed_amt

Line 953: FROM ozf_funds_all_b a,

949: c.base_line base_line,
950: c.frequency_period frequency_period,
951: c.converted_days conv_frequency_period, --Not used in current version.
952: c.repeat_frequency repeat_frequency
953: FROM ozf_funds_all_b a,
954: ozf_thresholds_all_b b,
955: ozf_threshold_rules_all c
956: WHERE a.threshold_id = b.threshold_id
957: AND a.status_code = 'ACTIVE'

Line 981: FROM ozf_Funds_All_b

977:
978: CURSOR c_owner(p_budget_id NUMBER)
979: IS
980: SELECT owner,parent_fund_id
981: FROM ozf_Funds_All_b
982: WHERE fund_id = p_budget_id;
983:
984: CURSOR c_parent_owner(p_budget_id NUMBER)
985: IS

Line 987: FROM ozf_Funds_All_b

983:
984: CURSOR c_parent_owner(p_budget_id NUMBER)
985: IS
986: SELECT owner
987: FROM ozf_Funds_All_b
988: WHERE fund_id = p_budget_id;
989:
990: CURSOR c_budget_name(p_budget_id NUMBER)
991: IS