APPS.OKL_SETUPFMACONSTRAINTS_PVT dependencies on OKL_FORMULAE_V

Line 85: p_fma_id IN Okl_Formulae_V.id%TYPE

81: x_return_status OUT NOCOPY VARCHAR2,
82: x_valid OUT NOCOPY BOOLEAN
83: ) IS
84: CURSOR okl_opdv_pk_csr (p_opd_id IN Okl_Operands_V.id%TYPE,
85: p_fma_id IN Okl_Formulae_V.id%TYPE
86: ) IS
87: SELECT '1'
88: FROM Okl_Operands_V opd,
89: Okl_Formulae_V fma

Line 89: Okl_Formulae_V fma

85: p_fma_id IN Okl_Formulae_V.id%TYPE
86: ) IS
87: SELECT '1'
88: FROM Okl_Operands_V opd,
89: Okl_Formulae_V fma
90: WHERE opd.ID = p_opd_id
91: AND fma.ID = p_fma_id
92: AND (opd.START_DATE > fma.START_DATE OR
93: NVL(opd.END_DATE, NVL(fma.END_DATE, OKL_API.G_MISS_DATE)) < NVL(fma.END_DATE, OKL_API.G_MISS_DATE));