APPS.OKS_AVLEXC_PVT dependencies on OKS_SERV_AVAILS_V

Line 366: from OKS_SERV_AVAILS_V

362: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
363: l_dummy_var VARCHAR2(1) := '?';
364: Cursor l_Srv_Csr Is
365: select 'x'
366: from OKS_SERV_AVAILS_V
367: where id = P_sav_id;
368:
369: Begin
370: If p_sav_id = OKC_API.G_MISS_NUM OR

Line 2134: FROM Oks_Serv_Avails_V

2130: ATTRIBUTE12,
2131: ATTRIBUTE13,
2132: ATTRIBUTE14,
2133: ATTRIBUTE15
2134: FROM Oks_Serv_Avails_V
2135: WHERE oks_serv_avails_v.id = p_id;
2136: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
2137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2138: l_row_notfound BOOLEAN := TRUE;

Line 2135: WHERE oks_serv_avails_v.id = p_id;

2131: ATTRIBUTE13,
2132: ATTRIBUTE14,
2133: ATTRIBUTE15
2134: FROM Oks_Serv_Avails_V
2135: WHERE oks_serv_avails_v.id = p_id;
2136: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
2137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2138: l_row_notfound BOOLEAN := TRUE;
2139: BEGIN