APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on CZ_RP_ENTRIES

Line 2455: FROM cz_rp_entries

2451: p_intent IN VARCHAR2) IS
2452: */
2453: CURSOR csr_template_folder(p_name IN VARCHAR2) IS
2454: SELECT object_id
2455: FROM cz_rp_entries
2456: WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID
2457: AND object_type = 'FLD'
2458: AND deleted_flag=0
2459: AND name = p_name;

Line 2475: l_folder_name cz_rp_entries.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:
2479: -- start debug log