DBA Data[Home] [Help]

APPS.OKC_PROCESS_PVT dependencies on OKC_PROCESS_DEFS_V

Line 397: from okc_process_defs_v pdf,

393:
394: --Check if the process definition is used by Conditions
395: Cursor check_condition_csr(p_pdf_id IN NUMBER) is
396: select '1'
397: from okc_process_defs_v pdf,
398: okc_outcomes_v out,
399: okc_condition_headers_v cnh
400: where pdf.id = out.pdf_id
401: and pdf.id = p_pdf_id

Line 406: from okc_process_defs_v pdf,

402: and out.cnh_id = cnh.id;
403:
404: Cursor check_qa_csr(p_pdf_id IN NUMBER) is
405: select '1'
406: from okc_process_defs_v pdf,
407: okc_qa_list_processes qa
408: where pdf.id = qa.pdf_id
409: and pdf.id = p_pdf_id;
410:

Line 413: from okc_process_defs_v pdf,

409: and pdf.id = p_pdf_id;
410:
411: Cursor check_k_process_csr(p_pdf_id IN NUMBER) is
412: select '1'
413: from okc_process_defs_v pdf,
414: okc_k_processes k
415: where pdf.id = k.pdf_id
416: and pdf.id = p_pdf_id;
417: