DBA Data[Home] [Help]

APPS.OKL_IRK_PVT dependencies on OKX_INS_PROVIDER_V

Line 756: FROM OKX_INS_PROVIDER_V

752: FROM OKX_COUNTRIES_V
753: WHERE id1 = p_irkv_rec.ic_code;
754: CURSOR okx_insurer_v_pk_csr (p_isu_id IN NUMBER) IS
755: SELECT 'x'
756: FROM OKX_INS_PROVIDER_V
757: WHERE OKX_INS_PROVIDER_V.PARTY_ID = p_isu_id;
758:
759: CURSOR okl_insurer_rankings_v_pk_csr IS
760: SELECT 'x'

Line 757: WHERE OKX_INS_PROVIDER_V.PARTY_ID = p_isu_id;

753: WHERE id1 = p_irkv_rec.ic_code;
754: CURSOR okx_insurer_v_pk_csr (p_isu_id IN NUMBER) IS
755: SELECT 'x'
756: FROM OKX_INS_PROVIDER_V
757: WHERE OKX_INS_PROVIDER_V.PARTY_ID = p_isu_id;
758:
759: CURSOR okl_insurer_rankings_v_pk_csr IS
760: SELECT 'x'
761: FROM okl_insurer_rankings

Line 821: p_token2_value => 'OKX_INS_PROVIDER_V',

817: p_msg_name => G_NO_PARENT_RECORD,
818: p_token1 => G_COL_NAME_TOKEN,
819: p_token1_value => 'Provider',
820: p_token2 => g_parent_table_token,
821: p_token2_value => 'OKX_INS_PROVIDER_V',
822: p_token3 => g_child_table_token,
823: p_token3_value => 'OKL_INSURER_RANKINGS');
824: -- notify caller of an error
825: l_return_status := OKC_API.G_RET_STS_ERROR;