APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on OZF_FUNDS_ALL_B

Line 26: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)

22: IS
23:
24: CURSOR c_leaf(p_quota_id NUMBER) IS
25: SELECT 'Y' from dual
26: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
27: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);
28:
29: CURSOR c_acct_Spread_OR_Selection(p_quota_start_date DATE) IS
30: SELECT decode(greatest(p_quota_start_date, sysdate), sysdate,'SPR','SEL')

Line 27: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);

23:
24: CURSOR c_leaf(p_quota_id NUMBER) IS
25: SELECT 'Y' from dual
26: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
27: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);
28:
29: CURSOR c_acct_Spread_OR_Selection(p_quota_start_date DATE) IS
30: SELECT decode(greatest(p_quota_start_date, sysdate), sysdate,'SPR','SEL')
31: FROM dual;

Line 35: FROM ozf_funds_all_b

31: FROM dual;
32:
33: CURSOR c_quota_start_date(p_quota_id NUMBER) IS
34: SELECT start_date_active
35: FROM ozf_funds_all_b
36: WHERE fund_id = p_quota_id;
37:
38: l_return VARCHAR2(1) := 'N';
39: l_quota_start_date DATE;

Line 73: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)

69: IS
70:
71: CURSOR c_leaf(p_quota_id NUMBER) IS
72: SELECT 'Y' from dual
73: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
74: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);
75:
76: CURSOR c_unallocated_amt_leaf(p_quota_id NUMBER) IS
77: SELECT TARGET Unallocated_Fund

Line 74: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);

70:
71: CURSOR c_leaf(p_quota_id NUMBER) IS
72: SELECT 'Y' from dual
73: WHERE exists(SELECT 1 FROM ozf_funds_all_b WHERE parent_fund_id IS NOT NULL AND fund_id = p_quota_id)
74: AND NOT EXISTS(select 1 FROM ozf_funds_all_b WHERE parent_fund_id = p_quota_id);
75:
76: CURSOR c_unallocated_amt_leaf(p_quota_id NUMBER) IS
77: SELECT TARGET Unallocated_Fund
78: FROM OZF_ACCOUNT_ALLOCATIONS

Line 334: UPDATE ozf_funds_all_b

330: CLOSE C_extra_fields;
331:
332: for l_fact_id in c_fact_id(p_alloc_id)
333: loop
334: UPDATE ozf_funds_all_b
335: SET start_period_name = l_start_period_name,
336: end_period_name = l_end_period_name,
337: product_spread_time_id = l_spread_time_id
338: WHERE fund_id = l_fact_id.act_metric_used_by_id;

Line 380: SELECT 1 FROM ozf_funds_all_b

376:
377: CURSOR c_leaf(p_quota_id NUMBER) IS
378: SELECT 'Y' from dual
379: WHERE exists(
380: SELECT 1 FROM ozf_funds_all_b
381: WHERE parent_fund_id IS NOT NULL
382: AND fund_id = p_quota_id)
383: AND NOT EXISTS(
384: select 1 FROM ozf_funds_all_b

Line 384: select 1 FROM ozf_funds_all_b

380: SELECT 1 FROM ozf_funds_all_b
381: WHERE parent_fund_id IS NOT NULL
382: AND fund_id = p_quota_id)
383: AND NOT EXISTS(
384: select 1 FROM ozf_funds_all_b
385: WHERE parent_fund_id = p_quota_id);
386:
387: l_return VARCHAR2(1) := 'N';
388:

Line 694: update ozf_funds_all_b

690:
691: IF(l_alloc_metric_used_by_id <> p_quota_id) THEN
692:
693: --Change the status of child quotas to cancelled (happens if the allocation is published)
694: update ozf_funds_all_b
695: set status_code = 'CANCELLED',
696: user_status_id = l_user_status_id
697: where fund_id in
698: (