APPS.CZ_CF_API dependencies on CZ_RP_ENTRIES

Line 4216: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'

4212: SELECT orig_sys_ref, NVL(config_engine_type,'L') INTO lOSR, lConfigEngineType
4213: FROM cz_devl_projects d
4214: WHERE d.deleted_flag = '0'
4215: AND d.devl_project_id = inDevlProjectId
4216: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
4217: AND object_type = 'PRJ' AND object_id = d.devl_project_id)
4218: AND orig_sys_ref IS NOT NULL;
4219: EXCEPTION
4220: WHEN NO_DATA_FOUND THEN

Line 4239: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'

4235: WHERE d.orig_sys_ref = lOSR
4236: AND d.deleted_flag = '0'
4237: AND NVL(d.import_enabled,'0') = '1'
4238: AND NVL(d.config_engine_type,'L') = lConfigEngineType
4239: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
4240: AND object_type = 'PRJ' AND object_id = d.devl_project_id) ;
4241:
4242: --dbms_output.put_line('model id from Orig_sys_ref ' || lModelId);
4243:

Line 4293: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'

4289: --Check whether model exists in repository
4290: SELECT orig_sys_ref INTO lOSR FROM cz_devl_projects d
4291: WHERE d.deleted_flag = '0'
4292: AND d.devl_project_id = inDevlProjectId
4293: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
4294: AND object_type = 'PRJ' AND object_id = d.devl_project_id)
4295: AND orig_sys_ref IS NOT NULL ;
4296: EXCEPTION
4297: WHEN NO_DATA_FOUND THEN