APPS.OKL_SETUPFORMULAE_PVT dependencies on OKL_OPERANDS_B

Line 348: FROM Okl_Operands_B opd

344: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Formulae_V.id%TYPE) IS
345: SELECT opd.ID ID,
346: opd.START_DATE START_DATE,
347: opd.END_DATE
348: FROM Okl_Operands_B opd
349: WHERE opd.fma_ID = p_fma_id;
350:
351: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
352: l_min_start_date DATE := NULL;

Line 430: FROM Okl_Operands_B opd

426:
427: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
428: p_start_date DATE, p_end_date DATE) IS
429: SELECT '1'
430: FROM Okl_Operands_B opd
431: WHERE opd.FMA_ID = p_fma_id
432: AND ((opd.start_date < p_start_date) OR
433: (NVL(opd.end_date, TO_DATE('31/12/9999', 'DD/MM/YYYY')) > p_end_date )) ;
434: