APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on ALL_SOURCE

Line 605: FROM all_source

601: AND owner = SUBSTR(p_procedure_name,1,INSTR(p_procedure_name,'.')-1);
602:
603: CURSOR csr_check_proc_exists (p_procedure_name VARCHAR2) IS
604: SELECT 'X'
605: FROM all_source
606: WHERE name = SUBSTR(p_procedure_name,
607: INSTR(p_procedure_name,'.')+1,
608: (INSTR(p_procedure_name,'.',1,2) -
609: INSTR(p_procedure_name,'.') - 1))