APPS.OKL_LEASE_APP_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 751: , OKL_COST_ADJUSTMENTS_B ADJ

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
755: AND ADJ.ADJUSTMENT_SOURCE_TYPE = cp_adj_src_type;

Line 954: , OKL_COST_ADJUSTMENTS_B ADJ

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')
958: AND AST.PARENT_OBJECT_ID = p_lsq_id;