DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKL_TRX_CSH_RECEIPT_B

Line 766: FROM OKL_TRX_CSH_RECEIPT_B A,

762: AND TRX_STATUS_CODE <> 'CANCELED';
763:
764: CURSOR check_upd_le_adv_rcpt_csr (p_khr_id NUMBER) IS
765: SELECT 1
766: FROM OKL_TRX_CSH_RECEIPT_B A,
767: OKL_TXL_RCPT_APPS_B B
768: WHERE A.ID = B.RCT_ID_DETAILS
769: AND A.RECEIPT_TYPE = 'ADV'
770: AND B.KHR_ID = p_khr_id;