DBA Data[Home] [Help]

APPS.OKL_OVD_PVT dependencies on OKL_OPT_RULES_V

Line 336: FROM okl_opt_rules_v

332: ,x_return_status OUT NOCOPY VARCHAR2)
333: IS
334: CURSOR okl_orlv_pk_csr (p_id IN NUMBER) IS
335: SELECT '1'
336: FROM okl_opt_rules_v
337: WHERE okl_opt_rules_v.id = p_id;
338:
339: l_orl_status VARCHAR2(1);
340: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 337: WHERE okl_opt_rules_v.id = p_id;

333: IS
334: CURSOR okl_orlv_pk_csr (p_id IN NUMBER) IS
335: SELECT '1'
336: FROM okl_opt_rules_v
337: WHERE okl_opt_rules_v.id = p_id;
338:
339: l_orl_status VARCHAR2(1);
340: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
341: l_row_notfound BOOLEAN := TRUE;