APPS.OKC_XPRT_IMPORT_CLAUSES_PVT dependencies on CZ_DEVL_PROJECTS

Line 1947: FROM cz_devl_projects

1943:
1944: -- CURSOR csr_clause_model_id(p_intent IN VARCHAR2) IS
1945: CURSOR csr_clause_model_id(p_orig_sys_ref IN VARCHAR2) IS
1946: SELECT devl_project_id
1947: FROM cz_devl_projects
1948: WHERE orig_sys_ref = p_orig_sys_ref
1949: AND devl_project_id = persistent_project_id
1950: AND deleted_flag = 0;
1951:

Line 1982: l_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

1978: l_run_id NUMBER;
1979: l_clause_folder_id NUMBER :=NULL;
1980: l_folder_desc VARCHAR2(255);
1981: l_import_status VARCHAR2(10);
1982: l_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
1983: l_clause_folder_name cz_rp_entries.name%TYPE;
1984:
1985: BEGIN
1986: