APPS.OKL_BPD_CAP_ADV_MON_PVT dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 153: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt

149: -------------------
150: -- get a contract id if not known
151: CURSOR c_get_contract_id (cp_contract_num IN VARCHAR2) IS
152: SELECT lpt.contract_id
153: FROM OKL_BPD_LEASING_PAYMENT_TRX_V lpt
154: WHERE lpt.contract_number = cp_contract_num
155: AND lpt.status = 'OP'
156: AND lpt.amount_due_remaining > 0
157: ORDER BY lpt.start_date;