DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_TYPES_V

Line 878: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE )

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

Line 3353: ,okl_trx_types_v b

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'