DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OKL_FEES_B

Line 944: FROM OKL_FEES_B FEE

940: -- cursor to find total Rollover Fee Amount for a Lease Application
941: CURSOR l_fee_csr(p_lsq_id NUMBER, p_fee_type VARCHAR2)
942: IS
943: SELECT NVL(SUM(FEE.FEE_AMOUNT), 0) FEE_AMOUNT
944: FROM OKL_FEES_B FEE
945: WHERE FEE.FEE_TYPE = p_fee_type
946: AND FEE.PARENT_OBJECT_CODE = 'LEASEQUOTE'
947: AND FEE.PARENT_OBJECT_ID = p_lsq_id;
948: