874: l_sysdate_trunc DATE;
875: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
876: l_post_to_gl_yn VARCHAR2(1);
877:
878: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE )
879: IS
880: SELECT id
881: FROM okl_trx_types_tl
882: WHERE name = p_transaction_type
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
3355: AND a.try_id = b.id
3356: --rkuttiya added for 12.1.1 Multi GAAP
3357: AND a.representation_type = 'PRIMARY'