[Home] [Help]
3963: AND DV.K_HEADER_ID = p_chr_id;
3964:
3965: CURSOR check_funding IS
3966: SELECT 'x'
3967: FROM OKE_K_FUND_ALLOCATIONS FA, OKE_K_FUNDING_SOURCES FS
3968: WHERE FA.PA_FLAG = 'Y'
3969: AND FA.FUNDING_SOURCE_ID = FS.FUNDING_SOURCE_ID
3970: AND FS.OBJECT_ID = p_chr_id;
3971:
4186: where dnz_chr_id = p_chr_id;
4187:
4188: cursor c_alloc is
4189: select fund_allocation_id
4190: from oke_k_fund_allocations
4191: where object_id = p_chr_id;
4192:
4193:
4194: cursor c_fund is