DBA Data[Home] [Help]

APPS.OKL_CLM_PVT dependencies on OKL_INS_POLICIES_V

Line 756: FROM OKL_INS_POLICIES_V

752: l_dummy_var VARCHAR2(1) := '?';
753: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
754: CURSOR okl_ipy_csr IS
755: SELECT 'x'
756: FROM OKL_INS_POLICIES_V
757: WHERE id = p_ipy_id;
758: Begin
759: IF ((p_ipy_id IS NOT NULL) AND (p_ipy_id = OKC_API.G_MISS_NUM)) THEN
760: -- enforce foreign key

Line 771: p_token2_value => 'OKL_INS_POLICIES_V',

767: p_msg_name => G_NO_PARENT_RECORD,
768: p_token1 => G_COL_NAME_TOKEN,
769: p_token1_value => 'Policy ID',
770: p_token2 => g_parent_table_token,
771: p_token2_value => 'OKL_INS_POLICIES_V',
772: p_token3 => g_child_table_token,
773: p_token3_value => 'OKL_INS_CLAIMS_B');
774: -- notify caller of an error
775: l_return_status := OKC_API.G_RET_STS_ERROR;