DBA Data[Home] [Help]

APPS.OZF_OBJFUNDSUM_PVT dependencies on OZF_FUNDS_ALL_B

Line 191: FROM ozf_funds_all_b

187: WHERE objfundsum_id = p_objfundsum_id;
188:
189: CURSOR c_get_fund_currency(p_fund_id IN NUMBER) IS
190: SELECT currency_code_tc
191: FROM ozf_funds_all_b
192: WHERE fund_id = p_fund_id;
193:
194: CURSOR c_get_reference(p_offer_id IN NUMBER) IS
195: SELECT arc_act_offer_used_by,act_offer_used_by_id

Line 1268: -- fund_id should be valid in ozf_funds_all_b

1264: END IF;
1265: RAISE Fnd_Api.G_EXC_ERROR;
1266: END IF;
1267:
1268: -- fund_id should be valid in ozf_funds_all_b
1269: IF ozf_utility_pvt.check_fk_exists (
1270: p_table_name=> 'OZF_FUNDS_ALL_B'
1271: ,p_pk_name=> 'FUND_ID'
1272: ,p_pk_value=> p_objfundsum_rec.fund_id

Line 1270: p_table_name=> 'OZF_FUNDS_ALL_B'

1266: END IF;
1267:
1268: -- fund_id should be valid in ozf_funds_all_b
1269: IF ozf_utility_pvt.check_fk_exists (
1270: p_table_name=> 'OZF_FUNDS_ALL_B'
1271: ,p_pk_name=> 'FUND_ID'
1272: ,p_pk_value=> p_objfundsum_rec.fund_id
1273: ) = fnd_api.g_false THEN
1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN