APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on DUAL

Line 25: SELECT 'Y' from dual

21: RETURN VARCHAR2
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

Line 31: FROM dual;

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;
32:
33: CURSOR c_quota_start_date(p_quota_id NUMBER) IS
34: SELECT start_date_active
35: FROM ozf_funds_all_b

Line 72: SELECT 'Y' from dual

68: RETURN NUMBER
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

Line 378: SELECT 'Y' from dual

374: --Added by kvattiku Mar 15, 04
375: --Will be used to ensure that the ozf_allocation_engine_pvt.allocate_target is called only for leaf quota nodes
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)