APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_FUNDS_ALL_B

Line 38: FROM ozf_funds_all_b

34: l_dummy NUMBER := 0;
35:
36: CURSOR c_fund_exists (p_fund_id IN NUMBER) IS
37: SELECT 1
38: FROM ozf_funds_all_b
39: WHERE fund_id = p_fund_id;
40:
41: CURSOR c_fund_num_exists (p_fund_num IN VARCHAR2) IS
42: SELECT fund_id

Line 43: FROM ozf_funds_all_b

39: WHERE fund_id = p_fund_id;
40:
41: CURSOR c_fund_num_exists (p_fund_num IN VARCHAR2) IS
42: SELECT fund_id
43: FROM ozf_funds_all_b
44: WHERE fund_number = p_fund_num;
45:
46: CURSOR c_valid_campaign (p_activity_id IN NUMBER) IS
47: SELECT campaign_id

Line 152: FROM ozf_funds_all_b

148: WHERE fund_id = p_fund_id;
149:
150: CURSOR c_curr_code (p_fund_id IN NUMBER) IS
151: SELECT currency_code_tc
152: FROM ozf_funds_all_b
153: WHERE fund_id = p_fund_id;
154:
155: --Order_Line_Id validation added for ER-6858324
156: CURSOR c_order_line (p_order_line_id IN NUMBER) IS

Line 533: SELECT 1 FROM ozf_funds_all_b

529: l_fund_id NUMBER;
530: l_gl_posted_flag VARCHAR2(1);
531:
532: CURSOR c_fund_type (p_fund_id IN NUMBER) IS
533: SELECT 1 FROM ozf_funds_all_b
534: WHERE fund_id = p_fund_id
535: AND fund_type = 'FULLY_ACCRUED'
536: AND accrual_basis= 'CUSTOMER'
537: AND liability_flag= 'Y';

Line 546: FROM ozf_funds_all_b

542: WHERE header_id = p_doc_number;
543:
544: CURSOR c_org_fund (p_fund_id IN NUMBER) IS
545: SELECT org_id
546: FROM ozf_funds_all_b
547: WHERE fund_id = p_fund_id;
548:
549: CURSOR c_orig_util_id (p_activity_id IN NUMBER, p_activity_type IN VARCHAR2,
550: p_fund_id IN NUMBER, p_product_id IN NUMBER, p_cust_acct_id IN NUMBER) IS