APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ARCHIVE_REFS

Line 6574: FROM cz_archive_refs

6570: SELECT DISTINCT devl_project_id
6571: BULK
6572: COLLECT
6573: INTO l_devl_project_tbl
6574: FROM cz_archive_refs
6575: WHERE cz_archive_refs.archive_id = p_archive_id
6576: AND cz_archive_refs.deleted_flag = '0'
6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6578: FROM cz_rp_entries

Line 6575: WHERE cz_archive_refs.archive_id = p_archive_id

6571: BULK
6572: COLLECT
6573: INTO l_devl_project_tbl
6574: FROM cz_archive_refs
6575: WHERE cz_archive_refs.archive_id = p_archive_id
6576: AND cz_archive_refs.deleted_flag = '0'
6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6578: FROM cz_rp_entries
6579: WHERE object_type = 'PRJ'

Line 6576: AND cz_archive_refs.deleted_flag = '0'

6572: COLLECT
6573: INTO l_devl_project_tbl
6574: FROM cz_archive_refs
6575: WHERE cz_archive_refs.archive_id = p_archive_id
6576: AND cz_archive_refs.deleted_flag = '0'
6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6578: FROM cz_rp_entries
6579: WHERE object_type = 'PRJ'
6580: AND deleted_flag = '0');

Line 6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id

6573: INTO l_devl_project_tbl
6574: FROM cz_archive_refs
6575: WHERE cz_archive_refs.archive_id = p_archive_id
6576: AND cz_archive_refs.deleted_flag = '0'
6577: AND cz_archive_refs.devl_project_id IN (SELECT object_id
6578: FROM cz_rp_entries
6579: WHERE object_type = 'PRJ'
6580: AND deleted_flag = '0');
6581:

Line 8027: FROM cz_archive_refs

8023: SELECT DISTINCT devl_project_id
8024: BULK
8025: COLLECT
8026: INTO l_devl_project_tbl
8027: FROM cz_archive_refs
8028: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
8029: AND cz_archive_refs.deleted_flag = '0'
8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id
8031: FROM cz_rp_entries

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

8024: BULK
8025: COLLECT
8026: INTO l_devl_project_tbl
8027: FROM cz_archive_refs
8028: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
8029: AND cz_archive_refs.deleted_flag = '0'
8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id
8031: FROM cz_rp_entries
8032: WHERE object_type = 'PRJ'

Line 8029: AND cz_archive_refs.deleted_flag = '0'

8025: COLLECT
8026: INTO l_devl_project_tbl
8027: FROM cz_archive_refs
8028: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
8029: AND cz_archive_refs.deleted_flag = '0'
8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id
8031: FROM cz_rp_entries
8032: WHERE object_type = 'PRJ'
8033: AND deleted_flag = '0');

Line 8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id

8026: INTO l_devl_project_tbl
8027: FROM cz_archive_refs
8028: WHERE cz_archive_refs.archive_id = l_arc_ref(modelId)
8029: AND cz_archive_refs.deleted_flag = '0'
8030: AND cz_archive_refs.devl_project_id IN (SELECT object_id
8031: FROM cz_rp_entries
8032: WHERE object_type = 'PRJ'
8033: AND deleted_flag = '0');
8034: IF (l_devl_project_tbl.COUNT > 0) THEN