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 920: from oke_k_fund_allocations

916: -- l_temp_val VARCHAR2(1) :='?';
917:
918: cursor c_fund_allocation_id (p_funding_source_id NUMBER) is
919: select fund_allocation_id
920: from oke_k_fund_allocations
921: where funding_source_id = p_funding_source_id
922: order by amount asc;
923:
924: l_allocation_id c_fund_allocation_id%ROWTYPE;

Line 1455: oke_k_fund_allocations f

1451:
1452: cursor c_source is
1453: select s.amount, s.hard_limit, s.revenue_hard_limit, s.funding_source_id
1454: from oke_k_funding_sources s,
1455: oke_k_fund_allocations f
1456: where s.funding_source_id = f.funding_source_id
1457: and f.fund_allocation_id = p_fund_allocation_id;
1458:
1459: cursor c_allocation (x_funding_source_id number)is

Line 1461: from oke_k_fund_allocations

1457: and f.fund_allocation_id = p_fund_allocation_id;
1458:
1459: cursor c_allocation (x_funding_source_id number)is
1460: select sum(amount), sum(hard_limit), sum(revenue_hard_limit)
1461: from oke_k_fund_allocations
1462: where funding_source_id = x_funding_source_id;
1463:
1464: l_funding_source_id NUMBER;
1465: l_s_amount NUMBER;