2982: -- Cursors plucked from OKL_LA_JE_PVT for a/c - START
2983: CURSOR fnd_pro_csr
2984: IS
2985: SELECT mo_global.get_current_org_id() l_fnd_profile
2986: FROM dual;
2987:
2988: fnd_pro_rec fnd_pro_csr%ROWTYPE;
2989:
2990: CURSOR ra_cust_csr
3346: -- return any rows, skip the reversal accounting part
3347: CURSOR check_upfront_trx_csr
3348: IS
3349: SELECT 1
3350: FROM dual
3351: WHERE EXISTS (SELECT a.id
3352: FROM okl_trx_contracts_all a
3353: ,okl_trx_types_v b
3354: WHERE a.khr_id = p_contract_id