DBA Data[Home] [Help]

APPS.OKC_AAV_PVT dependencies on OKC_CONDITION_OCCURS_V

Line 470: FROM Okc_Condition_Occurs_V

466: l_dummy_var VARCHAR2(1);
467:
468: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
469: SELECT '1'
470: FROM Okc_Condition_Occurs_V
471: WHERE okc_condition_occurs_v.id = p_id;
472:
473: l_dummy VARCHAR2(1);
474:

Line 471: WHERE okc_condition_occurs_v.id = p_id;

467:
468: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
469: SELECT '1'
470: FROM Okc_Condition_Occurs_V
471: WHERE okc_condition_occurs_v.id = p_id;
472:
473: l_dummy VARCHAR2(1);
474:
475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 673: FROM Okc_Condition_Occurs_V

669: CREATION_DATE,
670: LAST_UPDATED_BY,
671: LAST_UPDATE_DATE,
672: LAST_UPDATE_LOGIN
673: FROM Okc_Condition_Occurs_V
674: WHERE okc_condition_occurs_v.id = p_id;
675: l_okc_coev_pk okc_coev_pk_csr%ROWTYPE;
676: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
677: l_row_notfound BOOLEAN := TRUE;

Line 674: WHERE okc_condition_occurs_v.id = p_id;

670: LAST_UPDATED_BY,
671: LAST_UPDATE_DATE,
672: LAST_UPDATE_LOGIN
673: FROM Okc_Condition_Occurs_V
674: WHERE okc_condition_occurs_v.id = p_id;
675: l_okc_coev_pk okc_coev_pk_csr%ROWTYPE;
676: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
677: l_row_notfound BOOLEAN := TRUE;
678: BEGIN