DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_FEES_B

Line 902: FROM OKL_FEES_B FEE

898: -- cursor to find total Rollover Fee Amount for a Lease Application
899: CURSOR l_fee_csr(p_lsq_id NUMBER, p_fee_type VARCHAR2)
900: IS
901: SELECT NVL(SUM(FEE.FEE_AMOUNT), 0) FEE_AMOUNT
902: FROM OKL_FEES_B FEE
903: WHERE FEE.FEE_TYPE = p_fee_type
904: AND FEE.PARENT_OBJECT_CODE = 'LEASEQUOTE'
905: AND FEE.PARENT_OBJECT_ID = p_lsq_id;
906: