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 1219: FROM ozf_funds_all_b

1215: l_mode VARCHAR2(6) := 'UPDATE';
1216:
1217: CURSOR c_fund_id (p_fund_number IN VARCHAR2) IS
1218: SELECT fund_id
1219: FROM ozf_funds_all_b
1220: WHERE fund_number = p_fund_number;
1221:
1222: CURSOR c_fund_details (p_fund_id IN NUMBER) IS
1223: SELECT fund_number, short_name, fund_type, custom_setup_id, description, parent_fund_id, category_id,

Line 1423: FROM ozf_funds_all_b

1419: WHERE activity_market_segment_id = p_activity_market_segment_id;
1420:
1421: CURSOR c_segment_used_by_exists (p_segment_used_by_id IN NUMBER) IS
1422: SELECT 1
1423: FROM ozf_funds_all_b
1424: WHERE fund_id = p_segment_used_by_id;
1425:
1426: CURSOR c_segment_exists (p_segment IN VARCHAR2) IS
1427: SELECT 1

Line 2043: FROM ozf_funds_all_b

2039: WHERE activity_product_id = p_activity_product_id;
2040:
2041: CURSOR c_act_prod_used_by_exists (p_prod_used_by IN NUMBER) IS
2042: SELECT 1
2043: FROM ozf_funds_all_b
2044: WHERE fund_id = p_prod_used_by;
2045:
2046: CURSOR c_org_id (p_prod_used_by IN NUMBER) IS
2047: SELECT org_id

Line 2048: FROM ozf_funds_all_b

2044: WHERE fund_id = p_prod_used_by;
2045:
2046: CURSOR c_org_id (p_prod_used_by IN NUMBER) IS
2047: SELECT org_id
2048: FROM ozf_funds_all_b
2049: WHERE fund_id = p_prod_used_by;
2050:
2051: CURSOR c_inv_id_exists (p_inventory_id IN NUMBER, p_org_id IN NUMBER) IS
2052: SELECT 1

Line 2746: FROM ozf_funds_all_b

2742: l_list_line_tbl_type List_line_tbl_type;
2743:
2744: CURSOR c_list_header_id (p_fund_id IN NUMBER) IS
2745: SELECT plan_id
2746: FROM ozf_funds_all_b
2747: WHERE fund_id = p_fund_id;
2748:
2749: CURSOR c_fund_details (p_fund_id IN NUMBER) IS
2750: SELECT fund_number,

Line 2804: ozf_funds_all_b,

2800: CURSOR c_list_line(p_fund_id IN NUMBER) IS
2801: SELECT NVL(map.xref_line_id_value,line.list_line_id) list_line_id ,
2802: list_line_no
2803: FROM qp_list_lines line,
2804: ozf_funds_all_b,
2805: ozf_xref_map map
2806: WHERE fund_id = p_fund_id
2807: AND list_header_id = plan_id
2808: AND line.list_line_id = map.list_line_id(+);

Line 2866: FROM ozf_funds_All_b

2862: AND enabled_flag ='Y';
2863:
2864: CURSOR c_get_fund_no(cv_fund_number IN VARCHAR2) IS
2865: SELECT fund_number
2866: FROM ozf_funds_All_b
2867: WHERE fund_number = cv_fund_number;
2868:
2869: CURSOR c_threshold_id (cv_threshold_id IN NUMBER) IS
2870: SELECT threshold_id