APPS.OZF_QUOTA_PUB dependencies on OZF_FUNDS_ALL_B

Line 173: FROM ozf_funds_all_b

169: l_created_from VARCHAR2(30);
170:
171: CURSOR c_quota_exists (p_quota_id IN NUMBER) IS
172: SELECT 1
173: FROM ozf_funds_all_b
174: WHERE fund_type = 'QUOTA'
175: AND fund_id = p_quota_id;
176:
177: CURSOR c_quota_num_exists (p_quota_number IN VARCHAR2) IS

Line 179: FROM ozf_funds_all_b

175: AND fund_id = p_quota_id;
176:
177: CURSOR c_quota_num_exists (p_quota_number IN VARCHAR2) IS
178: SELECT fund_id
179: FROM ozf_funds_all_b
180: WHERE fund_type = 'QUOTA'
181: AND fund_number = p_quota_number;
182:
183: CURSOR c_custom_setup_exists (p_custom_setup_id IN NUMBER) IS

Line 981: FROM ozf_funds_all_b

977: l_period_exists NUMBER := NULL;
978:
979: CURSOR c_quota_exists (p_quota_id IN NUMBER) IS
980: SELECT 1
981: FROM ozf_funds_all_b
982: WHERE fund_type = 'QUOTA'
983: AND fund_id = p_quota_id;
984:
985: CURSOR c_quota_num_exists (p_quota_number IN VARCHAR2) IS

Line 987: FROM ozf_funds_all_b

983: AND fund_id = p_quota_id;
984:
985: CURSOR c_quota_num_exists (p_quota_number IN VARCHAR2) IS
986: SELECT fund_id
987: FROM ozf_funds_all_b
988: WHERE fund_type = 'QUOTA'
989: AND fund_number = p_quota_number;
990:
991: CURSOR c_period_exists (p_period IN VARCHAR2) IS

Line 1015: FROM ozf_funds_all_b

1011: AND period_name = p_period;
1012:
1013: CURSOR c_product_spread (p_quota_id IN NUMBER) IS
1014: SELECT product_spread_time_id
1015: FROM ozf_funds_all_b
1016: WHERE fund_id = p_quota_id;
1017:
1018: CURSOR c_hier_id_exists (p_hier_id IN NUMBER) IS
1019: SELECT heirarchy_id

Line 2541: FROM ozf_funds_all_b

2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2538:
2539: CURSOR c_quota_id (quota_number IN VARCHAR2) IS
2540: SELECT fund_id
2541: FROM ozf_funds_all_b
2542: WHERE fund_number = quota_number;
2543:
2544: CURSOR c_quota_details (quota_id IN NUMBER) IS
2545: SELECT fund_number, short_name, custom_setup_id, description, status_code,

Line 3012: from ozf_funds_all_b

3008: PROCEDURE delete_quota_allocations ( p_quota_id IN NUMBER) IS
3009:
3010: CURSOR c_child_quotas (c_quota_id NUMBER) IS
3011: SELECT fund_id
3012: from ozf_funds_all_b
3013: where fund_type = 'QUOTA'
3014: and parent_fund_id = c_quota_id;
3015:
3016: BEGIN

Line 3101: FROM ozf_funds_all_b

3097: l_object_version NUMBER;
3098:
3099: CURSOR c_valid_quota IS
3100: SELECT object_version_number
3101: FROM ozf_funds_all_b
3102: WHERE fund_type = 'QUOTA'
3103: AND fund_id = p_quota_id ;
3104:
3105:

Line 3222: FROM ozf_funds_all_b

3218: l_prod_exists NUMBER := NULL;
3219:
3220: CURSOR c_valid_quota IS
3221: SELECT 1
3222: FROM ozf_funds_all_b
3223: WHERE fund_type = 'QUOTA'
3224: AND fund_id = p_quota_id;
3225:
3226: CURSOR c_product_exists IS