APPS.OKC_CNL_PVT dependencies on OKC_PROCESS_DEFS_V

Line 821: FROM Okc_Process_Defs_V

817: CREATION_DATE,
818: LAST_UPDATED_BY,
819: LAST_UPDATE_DATE,
820: LAST_UPDATE_LOGIN
821: FROM Okc_Process_Defs_V
822: WHERE okc_process_defs_v.id = p_id;
823: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
824: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
825: l_row_notfound BOOLEAN := TRUE;

Line 822: WHERE okc_process_defs_v.id = p_id;

818: LAST_UPDATED_BY,
819: LAST_UPDATE_DATE,
820: LAST_UPDATE_LOGIN
821: FROM Okc_Process_Defs_V
822: WHERE okc_process_defs_v.id = p_id;
823: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
824: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
825: l_row_notfound BOOLEAN := TRUE;
826: BEGIN

Line 996: select 'X' from okc_process_defs_v pdf

992: l_temp NUMBER ;
993: v_pdfv_rec varchar2(1);
994:
995: CURSOR pdfv_cur IS
996: select 'X' from okc_process_defs_v pdf
997: where pdf.id = p_cnlv_rec.pdf_id
998: and pdf.usage = 'FUNCTION';
999:
1000: BEGIN