DBA Data[Home] [Help]

APPS.OZF_OBJFUNDSUM_PVT dependencies on OZF_FUNDS_ALL_B

Line 185: FROM ozf_funds_all_b

181: WHERE objfundsum_id = p_objfundsum_id;
182:
183: CURSOR c_get_fund_currency(p_fund_id IN NUMBER) IS
184: SELECT currency_code_tc
185: FROM ozf_funds_all_b
186: WHERE fund_id = p_fund_id;
187:
188: CURSOR c_get_reference(p_offer_id IN NUMBER) IS
189: SELECT arc_act_offer_used_by,act_offer_used_by_id

Line 1231: -- fund_id should be valid in ozf_funds_all_b

1227: END IF;
1228: RAISE Fnd_Api.G_EXC_ERROR;
1229: END IF;
1230:
1231: -- fund_id should be valid in ozf_funds_all_b
1232: IF ozf_utility_pvt.check_fk_exists (
1233: p_table_name=> 'OZF_FUNDS_ALL_B'
1234: ,p_pk_name=> 'FUND_ID'
1235: ,p_pk_value=> p_objfundsum_rec.fund_id

Line 1233: p_table_name=> 'OZF_FUNDS_ALL_B'

1229: END IF;
1230:
1231: -- fund_id should be valid in ozf_funds_all_b
1232: IF ozf_utility_pvt.check_fk_exists (
1233: p_table_name=> 'OZF_FUNDS_ALL_B'
1234: ,p_pk_name=> 'FUND_ID'
1235: ,p_pk_value=> p_objfundsum_rec.fund_id
1236: ) = fnd_api.g_false THEN
1237: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN