APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_POOL_PARTIES

Line 1267: from oke_pool_parties

1263: ) is
1264:
1265: cursor c_pool_party_id is
1266: select 'x'
1267: from oke_pool_parties
1268: where pool_party_id = p_pool_party_id
1269: FOR UPDATE OF pool_party_id NOWAIT;
1270:
1271: l_dummy_value VARCHAR2(1) := '?';

Line 1348: from oke_pool_parties

1344: p_return_status OUT NOCOPY VARCHAR2
1345: ) is
1346: cursor c_pool_party_id is
1347: select currency_code
1348: from oke_pool_parties
1349: where pool_party_id = p_pool_party_id
1350: and party_id = p_party_id
1351: FOR UPDATE OF pool_party_id NOWAIT;
1352:

Line 2576: from oke_pool_parties

2572: and party_id = p_party_id;
2573:
2574: cursor c_pool_party is
2575: select currency_code, start_date_active
2576: from oke_pool_parties
2577: where pool_party_id = p_pool_party_id
2578: and party_id = p_party_id
2579: and ((start_date_active is null) or
2580: (p_expiration_date is not null and

Line 3352: from oke_pool_parties

3348: order by allocated_amount desc;
3349:
3350: cursor c_pool_party_date is
3351: select start_date_active, end_date_active
3352: from oke_pool_parties
3353: where pool_party_id = p_pool_party_id;
3354:
3355: cursor c_ou is
3356: select nvl(allow_funding_across_ou_flag, 'N'),