APPS.OKL_LEASE_APP_PVT dependencies on OKL_ASSETS_B

Line 698: , OKL_ASSETS_B AST

694: CURSOR l_item_csr(p_lsq_id NUMBER)
695: IS
696: SELECT INV_ITEM_ID
697: FROM OKL_ASSET_COMPONENTS_B ASTC
698: , OKL_ASSETS_B AST
699: WHERE ASTC.ASSET_ID = AST.ID
700: AND AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
701: AND AST.PARENT_OBJECT_ID = p_lsq_id;
702: l_item_rec l_item_csr%ROWTYPE;

Line 708: FROM OKL_ASSETS_B AST

704: --Cursor to obtain the sum of adjustments of Lease Quote
705: CURSOR l_adj_sum_csr(p_lsq_id IN NUMBER, cp_adj_src_type IN VARCHAR2)
706: IS
707: SELECT SUM(ADJ.VALUE)
708: FROM OKL_ASSETS_B AST
709: , OKL_COST_ADJUSTMENTS_B ADJ
710: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
711: AND ADJ.PARENT_OBJECT_ID = AST.ID
712: AND AST.PARENT_OBJECT_ID = p_lsq_id

Line 894: FROM OKL_ASSETS_B ASS

890: --cursor to find total capital amount
891: CURSOR l_cap_amnt_csr(p_lsq_id NUMBER)
892: IS
893: SELECT NVL(SUM(ASS.OEC), 0) ASSET_AMOUNT
894: FROM OKL_ASSETS_B ASS
895: WHERE ASS.PARENT_OBJECT_CODE = 'LEASEQUOTE'
896: AND ASS.PARENT_OBJECT_ID = p_lsq_id;
897:
898: -- cursor to find total Rollover Fee Amount for a Lease Application

Line 911: FROM OKL_ASSETS_B AST

907: -- added for bug 6596860 --
908: CURSOR l_adj_sum_csr(p_lsq_id IN NUMBER)
909: IS
910: SELECT NVL(SUM(VALUE), 0 )
911: FROM OKL_ASSETS_B AST
912: , OKL_COST_ADJUSTMENTS_B ADJ
913: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
914: AND ADJ.PARENT_OBJECT_ID = AST.ID
915: AND ADJ.ADJUSTMENT_SOURCE_TYPE IN ('DOWN_PAYMENT', 'TRADEIN')