APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_POOL_PARTIES

Line 1281: from oke_pool_parties

1277: ) is
1278:
1279: cursor c_pool_party_id is
1280: select 'x'
1281: from oke_pool_parties
1282: where pool_party_id = p_pool_party_id
1283: FOR UPDATE OF pool_party_id NOWAIT;
1284:
1285: l_dummy_value VARCHAR2(1) := '?';

Line 1362: from oke_pool_parties

1358: p_return_status OUT NOCOPY VARCHAR2
1359: ) is
1360: cursor c_pool_party_id is
1361: select currency_code
1362: from oke_pool_parties
1363: where pool_party_id = p_pool_party_id
1364: and party_id = p_party_id
1365: FOR UPDATE OF pool_party_id NOWAIT;
1366:

Line 2710: from oke_pool_parties

2706: and party_id = p_party_id;
2707:
2708: cursor c_pool_party is
2709: select currency_code, start_date_active
2710: from oke_pool_parties
2711: where pool_party_id = p_pool_party_id
2712: and party_id = p_party_id
2713: and ((start_date_active is null) or
2714: (p_expiration_date is not null and

Line 3534: from oke_pool_parties

3530: order by allocated_amount desc;
3531:
3532: cursor c_pool_party_date is
3533: select start_date_active, end_date_active
3534: from oke_pool_parties
3535: where pool_party_id = p_pool_party_id;
3536:
3537: cursor c_ou is
3538: select nvl(allow_funding_across_ou_flag, 'N'),