APPS.OZF_FUNDS_PUB dependencies on OZF_FUNDS_ALL_B

Line 41: FROM ozf_funds_all_b

37: l_ledger_exists NUMBER := NULL;
38:
39: CURSOR c_fund_exists (p_fund_id IN NUMBER) IS
40: SELECT 1
41: FROM ozf_funds_all_b
42: WHERE fund_type <> 'QUOTA'
43: AND fund_id = p_fund_id;
44:
45: CURSOR c_fund_num_exists (p_fund_number IN VARCHAR2) IS

Line 47: FROM ozf_funds_all_b

43: AND fund_id = p_fund_id;
44:
45: CURSOR c_fund_num_exists (p_fund_number IN VARCHAR2) IS
46: SELECT fund_id
47: FROM ozf_funds_all_b
48: WHERE fund_type <> 'QUOTA'
49: AND fund_number = p_fund_number;
50:
51: CURSOR c_cust_setup (p_fund_type IN VARCHAR2) IS

Line 75: FROM ozf_funds_all_b

71: AND short_name = p_par_fund_name;
72:
73: CURSOR c_par_fund_exists (p_par_fund_id IN NUMBER) IS
74: SELECT 1
75: FROM ozf_funds_all_b
76: WHERE fund_type <> 'QUOTA'
77: AND fund_id = p_par_fund_id;
78:
79: CURSOR c_par_fund_name_exists (p_par_fund_name IN VARCHAR2) IS

Line 856: FROM ozf_funds_all_b

852: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type := p_modifier_list_rec;
853:
854: CURSOR c_list_header_id (p_fund_id IN NUMBER) IS
855: SELECT plan_id
856: FROM ozf_funds_all_b
857: WHERE fund_id = p_fund_id;
858:
859: BEGIN
860:

Line 1191: FROM ozf_funds_all_b

1187: l_mode VARCHAR2(6) := 'UPDATE';
1188:
1189: CURSOR c_fund_id (p_fund_number IN VARCHAR2) IS
1190: SELECT fund_id
1191: FROM ozf_funds_all_b
1192: WHERE fund_number = p_fund_number;
1193:
1194: CURSOR c_fund_details (p_fund_id IN NUMBER) IS
1195: SELECT fund_number, short_name, fund_type, custom_setup_id, description, parent_fund_id, category_id,

Line 1393: FROM ozf_funds_all_b

1389: WHERE activity_market_segment_id = p_activity_market_segment_id;
1390:
1391: CURSOR c_segment_used_by_exists (p_segment_used_by_id IN NUMBER) IS
1392: SELECT 1
1393: FROM ozf_funds_all_b
1394: WHERE fund_id = p_segment_used_by_id;
1395:
1396: CURSOR c_segment_exists (p_segment IN VARCHAR2) IS
1397: SELECT 1

Line 2013: FROM ozf_funds_all_b

2009: WHERE activity_product_id = p_activity_product_id;
2010:
2011: CURSOR c_act_prod_used_by_exists (p_prod_used_by IN NUMBER) IS
2012: SELECT 1
2013: FROM ozf_funds_all_b
2014: WHERE fund_id = p_prod_used_by;
2015:
2016: CURSOR c_org_id (p_prod_used_by IN NUMBER) IS
2017: SELECT org_id

Line 2018: FROM ozf_funds_all_b

2014: WHERE fund_id = p_prod_used_by;
2015:
2016: CURSOR c_org_id (p_prod_used_by IN NUMBER) IS
2017: SELECT org_id
2018: FROM ozf_funds_all_b
2019: WHERE fund_id = p_prod_used_by;
2020:
2021: CURSOR c_inv_id_exists (p_inventory_id IN NUMBER, p_org_id IN NUMBER) IS
2022: SELECT 1