APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_FUNDS_ALL_B

Line 48: FROM ozf_funds_all_b

44: l_offer_curr_code VARCHAR2(15);
45:
46: CURSOR c_fund_exists (p_fund_id IN NUMBER) IS
47: SELECT 1
48: FROM ozf_funds_all_b
49: WHERE fund_id = p_fund_id;
50:
51: CURSOR c_fund_num_exists (p_fund_num IN VARCHAR2) IS
52: SELECT fund_id

Line 53: FROM ozf_funds_all_b

49: WHERE fund_id = p_fund_id;
50:
51: CURSOR c_fund_num_exists (p_fund_num IN VARCHAR2) IS
52: SELECT fund_id
53: FROM ozf_funds_all_b
54: WHERE fund_number = p_fund_num;
55:
56: CURSOR c_valid_campaign (p_activity_id IN NUMBER) IS
57: SELECT campaign_id

Line 200: FROM ozf_funds_all_b

196: WHERE fund_id = p_fund_id;
197:
198: CURSOR c_curr_code (p_fund_id IN NUMBER) IS
199: SELECT currency_code_tc
200: FROM ozf_funds_all_b
201: WHERE fund_id = p_fund_id;
202:
203: --Order_Line_Id validation added for ER-6858324
204: CURSOR c_order_line (p_order_line_id IN NUMBER, p_header_id IN NUMBER) IS

Line 212: FROM hr_operating_units hr, ozf_funds_all_b fund

208: AND header_id = p_header_id;
209:
210: CURSOR c_org_id (p_org_id IN NUMBER, p_fund_id IN NUMBER) IS
211: SELECT 1
212: FROM hr_operating_units hr, ozf_funds_all_b fund
213: WHERE fund.fund_id = p_fund_id
214: AND hr.organization_id = p_org_id
215: AND hr.set_of_books_id = fund.ledger_id;
216:

Line 1136: SELECT 1 FROM ozf_funds_all_b

1132: l_rate NUMBER;
1133: l_utilization_id NUMBER;
1134:
1135: CURSOR c_fund_type (p_fund_id IN NUMBER) IS
1136: SELECT 1 FROM ozf_funds_all_b
1137: WHERE fund_id = p_fund_id
1138: AND fund_type = 'FULLY_ACCRUED'
1139: AND accrual_basis= 'CUSTOMER'
1140: AND liability_flag= 'Y';

Line 1150: FROM ozf_funds_all_b

1146: WHERE header_id = p_doc_number;
1147:
1148: CURSOR c_org_fund (p_fund_id IN NUMBER) IS
1149: SELECT org_id
1150: FROM ozf_funds_all_b
1151: WHERE fund_id = p_fund_id;
1152: */
1153:
1154: CURSOR c_orig_util_id (p_activity_id IN NUMBER, p_activity_type IN VARCHAR2,