APPS.OKE_PARTY_PVT dependencies on OKE_FUNDING_POOLS

Line 79: FROM OKE_FUNDING_POOLS

75:
76: l_dummy_val VARCHAR2(1):='?';
77: CURSOR l_csr IS
78: SELECT 'x'
79: FROM OKE_FUNDING_POOLS
80: WHERE FUNDING_POOL_ID = p_party_rec.funding_pool_id;
81:
82: BEGIN
83:

Line 116: p_token3_value =>'OKE_FUNDING_POOLS');

112: p_token1_value =>'FUNDING_POOL_ID',
113: p_token2 =>g_child_table_token,
114: p_token2_value =>G_VIEW,
115: p_token3 =>g_parent_table_token,
116: p_token3_value =>'OKE_FUNDING_POOLS');
117:
118: x_return_status := OKE_API.G_RET_STS_ERROR;
119: END IF;
120:

Line 433: FROM OKE_FUNDING_POOLS

429: l_parent_currency OKE_POOL_PARTIES.CURRENCY_CODE%TYPE;
430:
431: CURSOR l_conversion IS
432: SELECT CURRENCY_CODE
433: FROM OKE_FUNDING_POOLS
434: WHERE FUNDING_POOL_ID = p_party_rec.FUNDING_POOL_ID;
435:
436: BEGIN
437:

Line 989: FROM OKE_FUNDING_POOLS

985: RETURN (l_return_status);
986: END IF;
987:
988: SELECT CURRENCY_CODE INTO l_to_currency
989: FROM OKE_FUNDING_POOLS
990: WHERE FUNDING_POOL_ID = p_party_rec.FUNDING_POOL_ID;
991:
992: IF p_party_rec.CURRENCY_CODE <> l_to_currency THEN
993:

Line 1518: FROM OKE_FUNDING_POOLS

1514: FROM OKE_POOL_PARTIES
1515: WHERE pool_party_id = p_party_rec.pool_party_id;
1516:
1517: SELECT CURRENCY_CODE INTO l_to_currency
1518: FROM OKE_FUNDING_POOLS
1519: WHERE FUNDING_POOL_ID = l_pool_id;
1520:
1521: IF p_party_rec.CURRENCY_CODE <> l_to_currency THEN
1522:

Line 1660: FROM oke_funding_pools a,oke_pool_parties b

1656: END IF;
1657:
1658:
1659: SELECT a.currency_code INTO l_currency
1660: FROM oke_funding_pools a,oke_pool_parties b
1661: WHERE a.funding_pool_id = b.funding_pool_id
1662: AND b.pool_party_id=p_party_rec.pool_party_id;
1663:
1664: IF l_currency = p_party_rec.currency_code THEN