DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_TYPES_V

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

1032: l_sysdate_trunc DATE;
1033: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1034: l_post_to_gl_yn VARCHAR2(1);
1035:
1036: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE )
1037: IS
1038: SELECT id
1039: FROM okl_trx_types_tl
1040: WHERE name = p_transaction_type

Line 3557: ,okl_trx_types_v b

3553: SELECT 1
3554: FROM dual
3555: WHERE EXISTS (SELECT a.id
3556: FROM okl_trx_contracts_all a
3557: ,okl_trx_types_v b
3558: WHERE a.khr_id = p_contract_id
3559: AND a.try_id = b.id
3560: --rkuttiya added for 12.1.1 Multi GAAP
3561: AND a.representation_type = 'PRIMARY'