APPS.OKL_LEASE_APP_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 709: , OKL_COST_ADJUSTMENTS_B ADJ

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

Line 912: , OKL_COST_ADJUSTMENTS_B ADJ

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