APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on CZ_DEVL_PROJECTS

Line 2442: FROM cz_devl_projects

2438: p_tmpl_id IN NUMBER) IS
2439: */
2440: CURSOR csr_template_model_id(p_orig_sys_ref IN VARCHAR2) IS
2441: SELECT devl_project_id
2442: FROM cz_devl_projects
2443: WHERE orig_sys_ref = p_orig_sys_ref
2444: AND devl_project_id = persistent_project_id
2445: AND deleted_flag = 0;
2446:

Line 2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
2475: l_folder_name cz_rp_entries.name%TYPE;
2476:
2477: BEGIN
2478: