APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ARCHIVE_REFS

Line 6545: FROM cz_archive_refs

6541: SELECT DISTINCT devl_project_id
6542: BULK
6543: COLLECT
6544: INTO l_devl_project_tbl
6545: FROM cz_archive_refs
6546: WHERE cz_archive_refs.archive_id = p_archive_id
6547: AND cz_archive_refs.deleted_flag = '0'
6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6549: FROM cz_rp_entries

Line 6546: WHERE cz_archive_refs.archive_id = p_archive_id

6542: BULK
6543: COLLECT
6544: INTO l_devl_project_tbl
6545: FROM cz_archive_refs
6546: WHERE cz_archive_refs.archive_id = p_archive_id
6547: AND cz_archive_refs.deleted_flag = '0'
6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6549: FROM cz_rp_entries
6550: WHERE object_type = 'PRJ'

Line 6547: AND cz_archive_refs.deleted_flag = '0'

6543: COLLECT
6544: INTO l_devl_project_tbl
6545: FROM cz_archive_refs
6546: WHERE cz_archive_refs.archive_id = p_archive_id
6547: AND cz_archive_refs.deleted_flag = '0'
6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6549: FROM cz_rp_entries
6550: WHERE object_type = 'PRJ'
6551: AND deleted_flag = '0');

Line 6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id

6544: INTO l_devl_project_tbl
6545: FROM cz_archive_refs
6546: WHERE cz_archive_refs.archive_id = p_archive_id
6547: AND cz_archive_refs.deleted_flag = '0'
6548: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6549: FROM cz_rp_entries
6550: WHERE object_type = 'PRJ'
6551: AND deleted_flag = '0');
6552:

Line 7969: FROM cz_archive_refs

7965: SELECT DISTINCT devl_project_id
7966: BULK
7967: COLLECT
7968: INTO l_devl_project_tbl
7969: FROM cz_archive_refs
7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
7971: AND cz_archive_refs.deleted_flag = '0'
7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id
7973: FROM cz_rp_entries

Line 7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)

7966: BULK
7967: COLLECT
7968: INTO l_devl_project_tbl
7969: FROM cz_archive_refs
7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
7971: AND cz_archive_refs.deleted_flag = '0'
7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id
7973: FROM cz_rp_entries
7974: WHERE object_type = 'PRJ'

Line 7971: AND cz_archive_refs.deleted_flag = '0'

7967: COLLECT
7968: INTO l_devl_project_tbl
7969: FROM cz_archive_refs
7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
7971: AND cz_archive_refs.deleted_flag = '0'
7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id
7973: FROM cz_rp_entries
7974: WHERE object_type = 'PRJ'
7975: AND deleted_flag = '0');

Line 7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id

7968: INTO l_devl_project_tbl
7969: FROM cz_archive_refs
7970: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
7971: AND cz_archive_refs.deleted_flag = '0'
7972: AND cz_archive_refs.devl_project_id IN (SELECT object_id
7973: FROM cz_rp_entries
7974: WHERE object_type = 'PRJ'
7975: AND deleted_flag = '0');
7976: IF (l_devl_project_tbl.COUNT > 0) THEN