APPS.OKE_FUNDING_PUB dependencies on OKE_K_FUND_ALLOCATIONS

Line 21: from oke_k_fund_allocations

17: FUNCTION check_update_add_pa(p_fund_allocation_id NUMBER) RETURN BOOLEAN is
18:
19: cursor c_exist is
20: select 'Y'
21: from oke_k_fund_allocations
22: where fund_allocation_id = p_fund_allocation_id
23: and agreement_version is not null;
24:
25: l_dummy_value VARCHAR2(1) := '?';

Line 75: from oke_k_fund_allocations

71: FUNCTION check_update_add(p_fund_allocation_id NUMBER) RETURN BOOLEAN is
72:
73: cursor c_update is
74: select 'x'
75: from oke_k_fund_allocations
76: where fund_allocation_id = p_fund_allocation_id;
77:
78: l_dummy_value VARCHAR2(1) := '?';
79:

Line 207: from oke_k_fund_allocations

203: pa_conversion_type ,
204: pa_conversion_date ,
205: pa_conversion_rate,
206: funding_category
207: from oke_k_fund_allocations
208: where fund_allocation_id = p_fund_allocation_id;
209:
210: l_allocation_in_rec ALLOCATION_REC_IN_TYPE;
211:

Line 935: from oke_k_fund_allocations

931: -- l_temp_val VARCHAR2(1) :='?';
932:
933: cursor c_fund_allocation_id (p_funding_source_id NUMBER) is
934: select fund_allocation_id
935: from oke_k_fund_allocations
936: where funding_source_id = p_funding_source_id
937: order by amount asc;
938:
939: l_allocation_id c_fund_allocation_id%ROWTYPE;

Line 1470: oke_k_fund_allocations f

1466:
1467: cursor c_source is
1468: select s.amount, s.hard_limit, s.revenue_hard_limit, s.funding_source_id
1469: from oke_k_funding_sources s,
1470: oke_k_fund_allocations f
1471: where s.funding_source_id = f.funding_source_id
1472: and f.fund_allocation_id = p_fund_allocation_id;
1473:
1474: cursor c_allocation (x_funding_source_id number)is

Line 1476: from oke_k_fund_allocations

1472: and f.fund_allocation_id = p_fund_allocation_id;
1473:
1474: cursor c_allocation (x_funding_source_id number)is
1475: select sum(amount), sum(hard_limit), sum(revenue_hard_limit)
1476: from oke_k_fund_allocations
1477: where funding_source_id = x_funding_source_id;
1478:
1479: l_funding_source_id NUMBER;
1480: l_s_amount NUMBER;