APPS.OKL_LEASE_APP_PVT dependencies on OKL_ASSETS_B

Line 740: , OKL_ASSETS_B AST

736: CURSOR l_item_csr(p_lsq_id NUMBER)
737: IS
738: SELECT INV_ITEM_ID
739: FROM OKL_ASSET_COMPONENTS_B ASTC
740: , OKL_ASSETS_B AST
741: WHERE ASTC.ASSET_ID = AST.ID
742: AND AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
743: AND AST.PARENT_OBJECT_ID = p_lsq_id;
744: l_item_rec l_item_csr%ROWTYPE;

Line 750: FROM OKL_ASSETS_B AST

746: --Cursor to obtain the sum of adjustments of Lease Quote
747: CURSOR l_adj_sum_csr(p_lsq_id IN NUMBER, cp_adj_src_type IN VARCHAR2)
748: IS
749: SELECT SUM(ADJ.VALUE)
750: FROM OKL_ASSETS_B AST
751: , OKL_COST_ADJUSTMENTS_B ADJ
752: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
753: AND ADJ.PARENT_OBJECT_ID = AST.ID
754: AND AST.PARENT_OBJECT_ID = p_lsq_id

Line 936: FROM OKL_ASSETS_B ASS

932: --cursor to find total capital amount
933: CURSOR l_cap_amnt_csr(p_lsq_id NUMBER)
934: IS
935: SELECT NVL(SUM(ASS.OEC), 0) ASSET_AMOUNT
936: FROM OKL_ASSETS_B ASS
937: WHERE ASS.PARENT_OBJECT_CODE = 'LEASEQUOTE'
938: AND ASS.PARENT_OBJECT_ID = p_lsq_id;
939:
940: -- cursor to find total Rollover Fee Amount for a Lease Application

Line 953: FROM OKL_ASSETS_B AST

949: -- added for bug 6596860 --
950: CURSOR l_adj_sum_csr(p_lsq_id IN NUMBER)
951: IS
952: SELECT NVL(SUM(VALUE), 0 )
953: FROM OKL_ASSETS_B AST
954: , OKL_COST_ADJUSTMENTS_B ADJ
955: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
956: AND ADJ.PARENT_OBJECT_ID = AST.ID
957: AND ADJ.ADJUSTMENT_SOURCE_TYPE IN ('DOWN_PAYMENT', 'TRADEIN')