DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKL_TRX_CSH_RECEIPT_B

Line 782: FROM OKL_TRX_CSH_RECEIPT_B A,

778: AND TRX_STATUS_CODE <> 'CANCELED';
779:
780: CURSOR check_upd_le_adv_rcpt_csr (p_khr_id NUMBER) IS
781: SELECT 1
782: FROM OKL_TRX_CSH_RECEIPT_B A,
783: OKL_TXL_RCPT_APPS_B B
784: WHERE A.ID = B.RCT_ID_DETAILS
785: AND A.RECEIPT_TYPE = 'ADV'
786: AND B.KHR_ID = p_khr_id;